Withdata Software

Tag: Oracle

  • Batch transfer data from SQL Server tables to Oracle without programming

    Want to batch transfer data from SQL Server to Oracle ? Using DBCopier, a native GUI software, a SQL Server to Oracle converter, you can batch transfer data from SQL Server to Oracle easily and fast. Can run in GUI mode, Step by Step, just a few mouse clicks. Can run in Command line, for…

  • 4 easy steps to import CSV data to Oracle

    Want to import data from CSV/TSV/TXT file to Oracle ? Using FileToDB, a native GUI tool, you can import data from CSV/TSV/TXT file to Oracle in 4 simple steps, just a few mouse clicks! Support Windows, Linux, macOS Here you can download and install FileToDB. Import data from CSV file to Oracle in 4 steps…

  • Upsert data from TXT (“|” pipe delimited text) file to Oracle without programming

    Want to upsert data from TXT (“|” pipe delimited text) file to Oracle ? Upsert: inserts rows into a table if they do not already exist, or updates them if they do.</> Using FileToDB, a native GUI tool, you can upsert data from TXT (“|” pipe delimited text) file to Oracle easily and fast, no…

  • Batch import data from TXT (“;” semicolon delimited text) files to Oracle without programming

    Want to batch import data from TXT (“;” semicolon delimited text) files to Oracle ? Using FileToDB, a native GUI tool, you can batch import data from TXT (“;” semicolon delimited text) files to Oracle easily and fast, no need to program, just a few mouse clicks! Support Windows, Linux, macOS. Support large TXT (“;”…

  • Batch import data from TXT (“|” pipe delimited text) files to Oracle without programming

    Want to batch import data from TXT (“|” pipe delimited text) files to Oracle ? Using FileToDB, a native GUI tool, you can batch import data from TXT (“|” pipe delimited text) files to Oracle easily and fast, no need to program, just a few mouse clicks! Support Windows, Linux, macOS. Support large TXT (“|”…

  • Create Excel report from Oracle database

    Want to create Excel report from Oracle database? Using OracleToExcel, you can generate excel report from Oracle easily and fast, no need to program, no need learn VBA, just a few mouse clicks! Here you can download and install OracleToExcel. Create an Excel report based on Oracle Click “Export From Query” at task dialog. then…

  • 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 CLOB column Click “Start New Task…

  • 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 databases MongoToDB Ease your MongoDB to Oracle converting work DBBlobEditor Edit…

  • 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, https://www.withdata.com/blog/rdftooracle/ttl-to-oracle.html To import RDF N-Triples file (.nt, .ntriples) to Oracle, https://www.withdata.com/blog/rdftooracle/n-triples-to-oracle.html To import RDF N-Quads file (.nq,…

  • 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 query: select * from ( select*  from customers order by dbms_random.value ) where rownum <= 5; Some Oracle tools you can…