Withdata software has announced oracletoaccess 2.1, a data conversion tool that export Oracle data to access. OracleToAccess 2.1 add “Execute Sql from Command line”, add “Check Update” to menu, improve importing performance. OracleToAccess – Better tool for to export ... Read more
Tag Archives: Oracle
Withdata Software Released MysqlToOracle Version 1.2
Withdata software has announced mysqltooracle 1.2, a data conversion tool that convert MySQL data to Oracle database. Version 1.2 add “Execute Sql from Command line”, add “Check Update” to menu, improve importing performance. MysqlToOracle – convert Mysql data to ... Read more
Withdata Software Released MsSqlToOracle Version 1.2
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
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