Collections:
Load Data from External Tables in Oracle
How To Load Data from External Tables to Regular Tables in Oracle?
✍: FYIcenter.com
Once you have your data entered in a text file, and an external table defined to this text file, you can easily load data from this text file to a regular table. The following tutorial exercise shows you how to load data from the text file and the external table defined in the previous exercises to a regular table:
SQL> CREATE TABLE fyi_links ( id NUMBER(4) PRIMARY KEY, url VARCHAR2(16) NOT NULL, notes VARCHAR2(16), counts NUMBER(4), created DATE DEFAULT (sysdate) ); SQL> INSERT INTO fyi_links SELECT * FROM ext_fyi_links; 2 rows created. SQL> SELECT * FROM fyi_links; ID URL NOTES COUNTS CREATED --------- ---------------- ----------- -------- --------- 101 fyicenter.com Session 1 07-MAY-06 110 centerfyi.com Session 1 07-MAY-06 1101 dba.fyicenter Link #1 88 07-MAY-06 1110 dev.fyicenter Link #2 88 07-MAY-06
⇒ Data Pump Export Utility in Oracle
⇐ Run Queries on External Tables in Oracle
2016-10-15, 1524🔥, 0💬
Popular Posts:
How To Select All Columns of All Rows from a Table with a SELECT statement in SQL Server? The simple...
What To Do If the StartDB.bat Failed to Start the XE Instance in Oracle? If StartDB.bat failed to st...
How To Calculate Age in Days, Hours and Minutes in SQL Server Transact-SQL? On many Web sites, news ...
How To Verify Your PHP Installation in MySQL? PHP provides two execution interfaces: Command Line In...
How To Convert Numeric Values to Character Strings in MySQL? You can convert numeric values to chara...