Withdata software has announced mssqltooracle 1.2, a data conversion tool that convert SQL Server data to Oracle database. Version 1.2 add “Execute Sql from Command line”, add “Check Update” to menu, improve importing performance. MsSqlToOracle – convert SQL Server ... Read more
Tag Archives: Oracle
Withdata Software Released DB2ToOracle Version 1.2
Withdata software has announced db2tooracle 1.2, a data conversion tool that convert DB2 data to Oracle database. Version 1.2 add “Execute Sql from Command line”, add “Check Update” to menu, improve importing performance. DB2ToOracle – Convert DB2 data to ... Read more
Withdata Software Released AccessToOracle Version 2.1
Withdata software has announced accesstooracle 2.1, a data conversion tool that import Access data to oracle. AccessToOracle 2.1 add “Execute Sql from Command line”, add “Check Update” to menu, improve importing performance. AccessToOracle – Better tool for importing ... Read more
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 ... Read more
About Oracle error “Cannot load OCI DLL”
When you use Oracle tools that call Oracle client dll “oci.dll”, you may meet this error. [caption id="attachment_1847" align="alignnone" width="366"] Cannot load OCI DLL[/caption] When you use these Withdata ... Read more
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 ... Read more
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 ... Read more
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”. ... Read more
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 ... Read more
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 ... Read more