Tag: Oracle
-
Remove duplicate rows in Oracle
How to delete all duplicate rows and leave only one of them, in Oracle? DELETE FROM my_table WHERE rowid not in (SELECT MIN(rowid) FROM my_table GROUP BY column1, column2, column3…) ; Where column1, column2, etc. is the key you want to use. Relative links: Remove duplicate rows in MySQL Remove duplicate rows in SQL Server…
-
Withdata Software Released OraLoader Version 4.3
Withdata software has announced oraloader 4.3, a data conversion tool that helps dba and database developer import/export Oracle database from/to flat files and Excel files. OraLoader 4.3 add “Execute Sql from Command line”, add “Match filter (wildcard)” to “Import from folder”, add “Check Update” to menu, improve importing performance, and fix bug of exporting multiple…
-
Withdata Software Released OracleToMysql Version 1.2
Withdata software has announced oracletomysql 1.2, a data conversion tool that convert Oracle data to MySQL database. Version 1.2 add “Execute Sql from Command line”, add “Check Update” to menu, improve importing performance. OracleToMysql – convert Oracle data to Mysql OracleToMysql is convenient: 1. Easy visually config, just click on the mouse. 2. Displaying Progress,…
-
Withdata Software Released OracleToMsSql Version 1.2
Withdata software has announced oracletomssql 1.2, a data conversion tool that convert Oracle data to SQL Server database. Version 1.2 add “Execute Sql from Command line”, add “Check Update” to menu, improve importing performance. OracleToMsSql – convert Oracle data to SQL Server OracleToMsSql is convenient: 1. Easy visually config, just click on the mouse. 2.…
-
Withdata Software Released OracleToDB2 Version 1.2
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 DB2 OracleToDB2 is convenient: 1. Easy visually config, just click on the mouse. 2. Displaying Progress,…
-
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 Oracle to Access OracleToAccess is convenient: 1. Easy visually config, just click on the mouse. 2.…
-
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 Oracle MysqlToOracle is convenient: 1. Easy visually config, just click on the mouse. 2. Displaying Progress,…
-
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 data to Oracle MsSqlToOracle is convenient: 1. Easy visually config, just click on the mouse. 2.…
-
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 Oracle DB2ToOracle is convenient: 1. Easy visually config, just click on the mouse. 2. Displaying Progress,…
-
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 Access to Oracle AccessToOracle is convenient: 1. Easy visually config, just click on the mouse. 2. Displaying…