Withdata Software

Tag: Oracle

  • Withdata Software Released DB2ToOracle Version 1.3

    Withdata software has announced db2tooracle 1.3, a data conversion tool that convert DB2 data to Oracle database. Version 1.3 add “Task Schedule”, add support to DB2 XML type field, improve importing performance, and fix “division by zero” bug in importing process. DB2ToOracle – Convert DB2 data to Oracle DB2ToOracle is convenient: 1. Easy visually config,…

  • Withdata Software Released OracleToAccess Version 2.2

    Withdata software has announced oracletoaccess 2.2, a data conversion tool that export Oracle data to access. OracleToAccess 2.2 add “Task Schedule”, improve importing performance, and fix “division by zero” bug in importing process. OracleToAccess – Better tool for to export Oracle to Access OracleToAccess is convenient: 1. Easy visually config, just click on the mouse.…

  • Withdata Software Released AccessToOracle Version 2.2

    Withdata software has announced accesstooracle 2.2, a data conversion tool that import Access data to oracle. AccessToOracle 2.2 add “Task Schedule”, improve importing performance, and fix “division by zero” bug in importing process. AccessToOracle – Better tool for importing Access to Oracle AccessToOracle is convenient: 1. Easy visually config, just click on the mouse. 2.…

  • Withdata Software Released Withdata OracleToExcel 1.9

    Withdata software has announced withdata oracletoexcel 1.9, a data conversion tool that export Oracle data to excel. Withdata OracleToExcel 1.9 add “Task Schedule”, improve export performance, and fix “division by zero” bug in importing process. Withdata OracleToExcel – Export Oracle data to Excel Withdata OracleToExcel is convenient: 1. Easy visually config, just click on the…

  • Withdata Software Released OraLoader Version 4.4

    Withdata software has announced oraloader 4.4, a data conversion tool that helps dba and database developer import/export Oracle database from/to flat files and Excel files. OraLoader 4.4 add “Task Schedule”, improve import performance, and fix “division by zero” bug in importing process. OraLoader – Easy your Oracle importing/exporting work OraLoader is convenient: 1. Easy visually…

  • Withdata Software Released XlsToOra Version 2.9

    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 data to Oracle XlsToOra is convenient: 1. Easy visually config, just click on…

  • 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 >= :MIN_ROW_TO_FETCH like: select * from ( select a.*,…

  • 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 line”. OraLobEditor – Edit Oracle LOB data directly OraLobEditor is convenient: 1. Edit Oracle LOB(CLOB,BLOB)…

  • 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 given table in Mysql How to generate a CREATE TABLE statement for a given table in SQLite Some…

  • 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 OracleToExcel – Export Oracle data to Excel Withdata OracleToExcel is convenient: 1. Easy visually config, just click on…