Category: Oracle
-
About Oracle error “Cannot load OCI DLL”
When you use Oracle tools that call Oracle client dll “oci.dll”, you may meet this error. When you use these Withdata Softwares: FileToDB DBToFile DBLoader DBCopier DBBlobEditor MongoToDB DBToMongo you can choice “TCP/IP Connect” on Oracle logon form to avoid this error.
-
How to get column names from Oracle table
You can query the USER_TAB_COLUMNS table for table column metadata. SELECT table_name, column_name, data_type, data_length FROM USER_TAB_COLUMNS WHERE table_name = ‘My_Talbe_Name’ See also: How to get column names from Sql Server table How to get column names from DB2 table How to get column names from Mysql table How to get column names from PostgreSQL…
-
What is the dual table in Oracle
It’s a sort of dummy table with a single record used for selecting when you’re not actually interested in the data, but instead want the results of some system function in a select statement: e.g. select sysdate from dual; dual is a table which is created by oracle along with the data dictionary. It consists of exactly one…
-
Oracle Text Importer
Oracle Text Importer: OraLoader, OraCmd. OraLoader is a GUI importer, and OraCmd is a command-line importer. OraLoader is a data conversion tool that helps DBA and database developer import/export Oracle database from/to flat files and Excel files : http://www.withdata.com/oraloader.html . OraCmd is a command-line tools that can run sql command, import/export data, even without Oracle client…