Want to transfer data from MongoDB query results to Oracle table? Using MongoToDB, a native GUI tool, you can transfer data from MongoDB query results to Oracle table easily and fast, just a few mouse clicks! Support all MongoDB deployment types: standalone, replica set, sharded cluster, and ... Read more
Tag Archives: Oracle
Batch transfer data from MongoDB collections to Oracle tables without programming
Want to batch transfer data from MongoDB collections to Oracle ? Using MongoToDB, a native GUI tool, you can batch transfer data from MongoDB collections to Oracle easily and fast, just a few mouse clicks! Support all MongoDB deployment types: standalone, replica set, sharded cluster, and ... Read more
Batch import RTF files into Oracle BLOB without programming
Want to batch import RTF (Rich Text Format) documents into Oracle CLOB or BLOB column? Using OraLobEditor, you can import bulk rtf files into Oracle CLOB or BLOB easily and fast, just a few mouse clicks. Here you can download and install OraLobEditor. Batch import RTF documents to Oracle ... Read more
Some ETL (Extract-Transform-Load) tools for Oracle
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
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