Withdata Software provide some ETL (Extract-Transform-Load) tools for Oracle: FileToDB Load TXT, CSV, TSV, XML, JSON, Excel, SQL, RDF, INI data to Oracle DBToFile Export Oracle data to TXT, CSV, TSV, XML, JSON, Excel, SQL files DBCopier Copy data between Oracle and other rational ... Read more
Tag Archives: Oracle
Parse RDF file and save to Oracle
Want to parse RDF file and save to Oracle ? Want to schedule and automate this importing task? To import Xml format RDF file (.rdf, .owl) to Oracle, https://www.withdata.com/blog/rdftooracle/oracle-import-rdf.html To import RDF Turtle file (.ttl, .n3) to Oracle, ... Read more
How to select N random records from an Oracle table
If you want to select N random records from an Oracle table, you need to change the clause as follows: select * from ( select* from tableName order by dbms_random.value ) where rownum <= N; For example, to select 5 random customers in the customers table, you use the following ... Read more
Schedule and automate Oracle importing/exporting data task
Want to schedule and automate Oracle importing/exporting data task? Using OraLoader, you can scheduled importing/exporting data to Oracle task easily, just a few mouse clicks! Let computer automate repetitive Oracle importing/exporting data busy work, OraLoader make our life easier! Here you ... Read more
How to get index column names of a table from Oracle
SELECT i.index_name,c.column_name FROM user_ind_columns c, user_indexes i where c.index_name=i.index_name and c.table_name=i.table_name and i.TABLE_NAME='my_table_name' and i.TABLE_OWNER='my_schema_name' See also: How to get index column names of a table from DB2 How to get index column names of ... Read more
How to get primary key of a table from Oracle
SELECT cols.column_name FROM all_constraints cons, all_cons_columns cols WHERE cons.constraint_type = 'P' AND cons.constraint_name = cols.constraint_name AND cons.table_name = cols.table_name AND cons.owner = cols.owner AND cons.table_name='my_table_name' AND cons.owner='my_schema_name' See ... Read more
Withdata Software Released OraLobEditor Version 3.7
Withdata software has announced oralobeditor 3.7, a tool that helps you edit Oracle lob (blob, clob) data directly. Version 3.7 Add “Create sub folders by field name”. Add “turning off log” in command line. OraLobEditor – Edit Oracle LOB data directly OraLobEditor is ... Read more
About Oracle error “OUI-10137”
When install (reinstall) Oracle 12c on windows server 2008 r2 64bit, if you meet this error “oui-10137”, you should remove folder “c:\program files\oracle”, then try again. ... Read more
Withdata Software Released OracleToExcel Version 2.0
Withdata software has announced oracletoexcel 2.0, a data conversion tool that export Oracle data to excel. Version 2.0 Add “turning off log” in command line. Withdata OracleToExcel – Tool for exporting Oracle data to Excel Withdata OracleToExcel is convenient: 1. Easy visually ... Read more
Withdata Software Released OraLoader Version 4.5
Withdata software has announced oraloader 4.5, a data conversion tool that helps dba and database developer import/export Oracle database from/to flat files and Excel files. Version 4.5 Add “Bad File” to log failed import records. Add “turning off log” in command line. Fix ... Read more