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 ... Read more
Tag Archives: Oracle
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 ... Read more
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. ... Read more
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 ... Read more
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 ... Read more
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 ... Read more
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. ... Read more
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 ... Read more
Withdata Software Released OracleToSqlite Version 1.0
Withdata software has announced oracletosqlite 1.0, a data conversion tool that convert Oracle data to SQLite database. Version 1.0 is the first release. OracleToSqlite – Convert Oracle data to SQLite OracleToSqlite is convenient: 1. Easy visually config, just click on the mouse. 2. ... Read more
Withdata Software Released OracleToPostgres Version 1.0
Withdata software has announced oracletopostgres 1.0, a data conversion tool that convert Oracle data to PostgreSQL database. Version 1.0 is the first release. OracleToPostgres – Convert Oracle data to PostgreSQL OracleToPostgres is convenient: 1. Easy visually config, just click on the ... Read more