Interview Questions Answers.ORG
Interviewer And Interviewee Guide
Interviews
Quizzes
Home
Quizzes
Interviews DB Oracle Interviews:Concepts and ArchitectureData AccessDatabase ArchitectureDatabase ManagementDatabase Security OracleDistributed ProcessingFlexfieldForms ReportsGeneral OracleMemory ManagementMTO-SAP Financial AccountingOCIOracle AOLOracle AROracle Backup RecoveryOracle D2KOracle DatabaseOracle Database DeveloperOracle DB OptimizationOracle DBAOracle DeveloperOracle ETLOracle Forms 3.0Oracle Forms 4.0Oracle GLOracle PL-SQLOracle RMANOracle ScenariosOracle SecurityOracle SQLOracle System ArchitectureOracle Technology Network (OTN)Programmatic ConstructsRAC (Real Application Clusters)SQL Plus
Copyright © 2018. All Rights Reserved
Oracle Database Interview Question:
How To Load Data from External Tables to Regular Tables?
Submitted by: AdministratorOnce 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 ggl_links (
id NUMBER(4) PRIMARY KEY,
url VARCHAR2(16) NOT NULL,
notes VARCHAR2(16),
counts NUMBER(4),
created DATE DEFAULT (sysdate)
);
SQL> INSERT INTO ggl_links SELECT * FROM ext_ggl_links;
2 rows created.
SQL> SELECT * FROM ggl_links;
<pre> ID URL NOTES COUNTS CREATED
--------- ---------------- ----------- -------- ---------
101 globalguideline.com Session 1 07-MAY-06
110 centerggl.com Session 1 07-MAY-06
1101 www.globalguideline Link #1 88 07-MAY-06
1110 www.globalguideline Link #2 88 07-MAY-06</pre>
Submitted by: Administrator
SQL> CREATE TABLE ggl_links (
id NUMBER(4) PRIMARY KEY,
url VARCHAR2(16) NOT NULL,
notes VARCHAR2(16),
counts NUMBER(4),
created DATE DEFAULT (sysdate)
);
SQL> INSERT INTO ggl_links SELECT * FROM ext_ggl_links;
2 rows created.
SQL> SELECT * FROM ggl_links;
<pre> ID URL NOTES COUNTS CREATED
--------- ---------------- ----------- -------- ---------
101 globalguideline.com Session 1 07-MAY-06
110 centerggl.com Session 1 07-MAY-06
1101 www.globalguideline Link #1 88 07-MAY-06
1110 www.globalguideline Link #2 88 07-MAY-06</pre>
Submitted by: Administrator
Copyright 2007-2024 by Interview Questions Answers .ORG All Rights Reserved.
https://InterviewQuestionsAnswers.ORG.
https://InterviewQuestionsAnswers.ORG.