Withdata software has announced xlstoora 2.9, a data conversion tool that import Excel data to Oracle database. XlsToOra 2.9 add “Task Schedule”, improve import performance, and fix “division by zero” bug in importing process. XlsToOra – A better way to import Excel ... Read more
Tag Archives: Oracle
How to limit the number of rows returned by an Oracle query after ordering
In MySQL, you can use “Limit n,m”, like this: select * from sometable order by name limit 20,10 How to do in Oracle? select * from ( select a.*, ROWNUM rnum from ( <your_query_goes_here, with order by> ) a where ROWNUM <= :MAX_ROW_TO_FETCH ) where rnum >= ... Read more
Withdata Software Released OraLobEditor 3.5
Withdata software has announced oralobeditor 3.5, a tool that helps you edit Oracle lob(clob,blob) data directly. OraLobEditor 3.5 add PDF View, add “Execute Sql from Command line”, improve logon form, improve “Check update”, and fix bug on “Execute from command ... Read more
How to generate a CREATE TABLE statement for a given table in Oracle
select dbms_metadata.get_ddl('TABLE', 'the_table_name', 'the_schema_name') from dual Replace “the_table_name” and “the_schema_name” with yours. See also: How to generate a CREATE TABLE statement for a given table in SQL Server How to generate a CREATE TABLE statement for a ... Read more
Withdata Software Released Withdata OracleToExcel 1.8
Withdata software has announced withdata oracletoexcel 1.8, a data conversion tool that export Oracle data to excel. Withdata OracleToExcel 1.8 add “Execute Sql from Command line”, add “Check Update” to menu,and fix “Execute update sql error”. Withdata ... Read more
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 ... Read more
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 ... Read more
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 ... Read more
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 ... Read more
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 ... Read more