Withdata Software

Tag: Oracle

  • Replace (Update/Insert) a row into Oracle table – Merge into

    In Mysql,  if you want to either updates or inserts a row in a table, depending if the table already has a row that matches the data, you can use “ON DUPLICATE KEY UPDATE”. How to do it in Oracle? Use “merge into” . MERGE INTO employees USING dual ON ( “id”=123456 ) WHEN MATCHED THEN…

  • About Oracle error “Cannot load OCI DLL”

    When you use Oracle tools that call Oracle client dll “oci.dll”, you may meet this error. When you use these Withdata Softwares: FileToDB DBToFile DBLoader DBCopier DBBlobEditor MongoToDB DBToMongo you can choice “TCP/IP Connect” on Oracle logon form to avoid this error.

  • How to get column names from Oracle table

    You can query the USER_TAB_COLUMNS table for table column metadata. SELECT table_name, column_name, data_type, data_length FROM USER_TAB_COLUMNS WHERE table_name = ‘My_Talbe_Name’ See also: How to get column names from Sql Server table How to get column names from DB2 table How to get column names from Mysql table How to get column names from PostgreSQL…

  • What is the dual table in Oracle

    It’s a sort of dummy table with a single record used for selecting when you’re not actually interested in the data, but instead want the results of some system function in a select statement: e.g. select sysdate from dual; dual is a table which is created by oracle along with the data dictionary. It consists of exactly one…

  • Notes about Import Unicode data from Excel to Oracle

    1. Download FileToDB from here. 2. Check “UseUnicode” box on Oracle logon window. 3. Create your field as “NCLOB”, not “CLOB”.

  • View Oracle CLOB Data

    OraLobEditor is a database tool that can view Oracle CLOB data directly. Use OraLobEditor, you can view Oracle CLOB visually, do not need program with PL/SQL (or other program languages) to convert CLOB data to file. And you can save CLOB data to file and view also. Easy to use View LOB (BLOB, CLOB) data…

  • View Oracle BLOB Data

    OraLobEditor is a database tool that can view Oracle BLOB data directly. Use OraLobEditor, you can view Oracle BLOB visually, do not need program with PL/SQL (or other program languages) to convert BLOB data to file. And you can save BLOB data to file and view also. Easy to use View LOB (BLOB, CLOB) data…

  • Read Oracle CLOB Data

    OraLobEditor is a database tool that can read Oracle CLOB data directly. Use OraLobEditor, you can read Oracle CLOB visually, do not need program with PL/SQL (or other program languages) to convert CLOB data to file. And you can save CLOB data to file and read also. Easy to use Read LOB (BLOB, CLOB) data…

  • Read Oracle BLOB Data

    OraLobEditor is a database tool that can read Oracle BLOB data directly. Use OraLobEditor, you can read Oracle BLOB visually, do not need program with PL/SQL (or other program languages) to convert BLOB data to file. And you can save BLOB data to file and read also. Easy to use Read LOB (BLOB, CLOB) data…

  • Import data to Oracle

    OraCmd is a command-line tools that can run sql command, import/export data, even without Oracle client. OraCmd takes the pain out of manual importing/exporting tasks, and avoids installing the Oracle client. Convenient, powerful Import Oracle data from file(csv, txt). Import Oracle data to other schema. Import Oracle CLOB data. Replace SQL*Loader. Custom import date format.…