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
Tag Archives: Oracle
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
Notes about Import Unicode data from Excel to Oracle
1. Download FileToDB from here. 2. Check “UseUnicode” box on Oracle logon window. 3. Create your field as “NCLOB”, not “CLOB”. ... Read more
View Oracle CLOB Data
OraLobEditor is a database tool that can view Oracle CLOB data directly. Use OraLobEditor, you can view Oracle CLOB visually, do not need program with PL/SQL (or other program languages) to convert CLOB data to file. And you can save CLOB data to file and view also. Easy to use View LOB ... Read more
View Oracle BLOB Data
OraLobEditor is a database tool that can view Oracle BLOB data directly. Use OraLobEditor, you can view Oracle BLOB visually, do not need program with PL/SQL (or other program languages) to convert BLOB data to file. And you can save BLOB data to file and view also. Easy to use View LOB ... Read more
Read Oracle CLOB Data
OraLobEditor is a database tool that can read Oracle CLOB data directly. Use OraLobEditor, you can read Oracle CLOB visually, do not need program with PL/SQL (or other program languages) to convert CLOB data to file. And you can save CLOB data to file and read also. Easy to use Read LOB ... Read more
Read Oracle BLOB Data
OraLobEditor is a database tool that can read Oracle BLOB data directly. Use OraLobEditor, you can read Oracle BLOB visually, do not need program with PL/SQL (or other program languages) to convert BLOB data to file. And you can save BLOB data to file and read also. Easy to use Read LOB ... Read more
Import data to Oracle
OraCmd is a command-line tools that can run sql command, import/export data, even without Oracle client. OraCmd takes the pain out of manual importing/exporting tasks, and avoids installing the Oracle client. Convenient, powerful Import Oracle data from file(csv, txt). Import Oracle data to ... Read more
Export Oracle data
OraCmd is the fast and easy command-line tool to import/export data, even without Oracle client. OraCmd takes the pain out of manual importing/exporting tasks, and avoids installing the Oracle client. Convenient, powerful Export from both table and query. Export all tables data in a schema to ... Read more
Alternative for SQL*Loader
OraCmd is a command-line tools that can run sql command, import/export data, even without Oracle client. OraCmd takes the pain out of manual importing/exporting tasks, and avoids installing the Oracle client. Convert SQL*Loader control file to OraCmd command To use SQL*Loader you have to ... Read more