Categories:
.NET (357)
C (330)
C++ (183)
CSS (84)
DBA (2)
General (7)
HTML (4)
Java (574)
JavaScript (106)
JSP (66)
Oracle (114)
Perl (46)
Perl (1)
PHP (1)
PL/SQL (1)
RSS (51)
Software QA (13)
SQL Server (1)
Windows (1)
XHTML (173)
Other Resources:
How To Load Data from External Tables to Regular Tables
How To Load Data from External Tables to Regular Tables? - Oracle DBA FAQ - Loading and Exporting Data
✍: 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
2007-05-01, 5738👍, 0💬
Popular Posts:
How do we get the current culture of the environment in windows and ASP.NET? “CultureInfo.CurrentCul. ..
How To Change System Global Area (SGA)? - Oracle DBA FAQ - Introduction to Oracle Database 10g Expre...
How To Analyze Tables with "mysqlcheck"? - MySQL FAQs - Administrator Tools for Managing MySQL Serve...
What does XmlValidatingReader class do? XmlTextReader class does not validate the contents of an XML...
If client side validation is enabled in your Web page, does that mean server side code is not run? W...