Withdata software has announced oracletodb2 1.2, a data conversion tool that convert Oracle data to DB2 database. Version 1.2 add “Execute Sql from Command line”, add “Check Update” to menu, improve importing performance. OracleToDB2 – convert Oracle data to ... Read more
Tag Archives: Oracle
Withdata Software Released OracleToAccess Version 2.1
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
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