When you use Oracle tools that call Oracle client dll “oci.dll”, you may meet this error. [caption id="attachment_1847" align="alignnone" width="366"] Cannot load OCI DLL[/caption] When you use these Withdata ... Read more
Category Archives: Oracle
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 ... Read more
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 ... Read more
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 : ... Read more