Tag: Oracle
-
Schedule and automate Oracle importing/exporting data task
Want to schedule and automate Oracle importing/exporting data task? Using OraLoader, you can scheduled importing/exporting data to Oracle task easily, just a few mouse clicks! Let computer automate repetitive Oracle importing/exporting data busy work, OraLoader make our life easier! Here you can download and install OraLoader. Schedule and automate Oracle importing/exporting data task 1. Select…
-
How to get index column names of a table from Oracle
SELECT i.index_name,c.column_name FROM user_ind_columns c, user_indexes i where c.index_name=i.index_name and c.table_name=i.table_name and i.TABLE_NAME=’my_table_name’ and i.TABLE_OWNER=’my_schema_name’ See also: How to get index column names of a table from DB2 How to get index column names of a table from SQL Server How to get index column names of a table from MySQL How to get index…
-
How to get primary key of a table from Oracle
SELECT cols.column_name FROM all_constraints cons, all_cons_columns cols WHERE cons.constraint_type = ‘P’ AND cons.constraint_name = cols.constraint_name AND cons.table_name = cols.table_name AND cons.owner = cols.owner AND cons.table_name=’my_table_name’ AND cons.owner=’my_schema_name’ See also: How to get primary key of a table from PostgreSQL How to get primary key of a table from SQLite How to get primary key of…
-
Withdata Software Released OraLobEditor Version 3.7
Withdata software has announced oralobeditor 3.7, a tool that helps you edit Oracle lob (blob, clob) data directly. Version 3.7 Add “Create sub folders by field name”. Add “turning off log” in command line. OraLobEditor – Edit Oracle LOB data directly OraLobEditor is convenient: 1. Edit LOB (BLOB, CLOB) data directly. 2. Easy to view…
-
About Oracle error “OUI-10137”
When install (reinstall) Oracle 12c on windows server 2008 r2 64bit, if you meet this error “oui-10137”, you should remove folder “c:\program files\oracle”, then try again.
-
Withdata Software Released OracleToExcel Version 2.0
Withdata software has announced oracletoexcel 2.0, a data conversion tool that export Oracle data to excel. Version 2.0 Add “turning off log” in command line. Withdata OracleToExcel – Tool for exporting Oracle data to Excel Withdata OracleToExcel is convenient: 1. Easy visually config, just click on the mouse. 2. Displaying Progress, time estimation. 3. Saving…
-
Withdata Software Released OraLoader Version 4.5
Withdata software has announced oraloader 4.5, a data conversion tool that helps dba and database developer import/export Oracle database from/to flat files and Excel files. Version 4.5 Add “Bad File” to log failed import records. Add “turning off log” in command line. Fix bug “failed load part columns data in command line”. Add an option…
-
Withdata Software Released XlsToOra Version 3.0
Withdata software has announced xlstoora 3.0, a data conversion tool that import Excel data to Oracle database. Version 3.0 Add “turning off log” in command line. Add “Bad File” to log failed import records. Fix bug “falied load part columns data in command line” XlsToOra – Better tool to import Excel data to Oracle XlsToOra…
-
Withdata Software Released SqliteToOracle Version 1.0
Withdata software has announced sqlitetooracle 1.0, a data conversion tool that convert SQLite data to Oracle database. Version 1.0 is the first release. SqliteToOracle – Convert SQLite data to Oracle SqliteToOracle is convenient: 1. Easy visually config, just click on the mouse. 2. Displaying Progress, time estimation. 3. Saving and loading session parameters, let you…
-
Withdata Software Released PostgresToOracle Version 1.0
Withdata software has announced postgrestooracle 1.0, a data conversion tool that convert PostgreSQL data to Oracle database. Version 1.0 is the first release. PostgresToOracle – Convert PostgreSQL data to Oracle PostgresToOracle is convenient: 1. Easy visually config, just click on the mouse. 2. Displaying Progress, time estimation. 3. Saving and loading session parameters, let you…