How To Run Queries on External Tables?
Submitted by: AdministratorIf you have an external table defined as a text file with the ORACLE_LOADER driver, you can add data to the text file, and query the text file through the external table. By default, data fields in the text file should be terminated by ','. The tutorial exercise below shows you how add data to the external table defined in the previous exercise:
>edit /oraclexe/test/ext_ggl_links.txt
1101,www.globalguideline,Link #1,88,07-MAY-06
1110,www.globalguideline,Link #2,88,07-MAY-06
>sqlplus /nolog
SQL> connect HR/globalguideline
SQL> SELECT * FROM ext_ggl_links;
<pre> ID URL NOTES COUNTS CREATED
--------- ---------------- ----------- -------- ---------
1101 www.globalguideline Link #1 88 07-MAY-06
1110 www.globalguideline Link #2 88 07-MAY-06</pre>
Submitted by: Administrator
>edit /oraclexe/test/ext_ggl_links.txt
1101,www.globalguideline,Link #1,88,07-MAY-06
1110,www.globalguideline,Link #2,88,07-MAY-06
>sqlplus /nolog
SQL> connect HR/globalguideline
SQL> SELECT * FROM ext_ggl_links;
<pre> ID URL NOTES COUNTS CREATED
--------- ---------------- ----------- -------- ---------
1101 www.globalguideline Link #1 88 07-MAY-06
1110 www.globalguideline Link #2 88 07-MAY-06</pre>
Submitted by: Administrator
Read Online Oracle Database Job Interview Questions And Answers
Top Oracle Database Questions
☺ | What Is Input Buffer in SQL*Plus? |
☺ | What Is the Relation of a User Account and a Schema? |
☺ | How To Invoke the Data Pump Import Utility? |
☺ | How Oracle Handles Dead Locks? |
☺ | What Happens to Indexes If You Drop a Table? |
Top DB Oracle Categories
☺ | Oracle PL-SQL Interview Questions. |
☺ | Oracle DBA Interview Questions. |
☺ | Oracle D2K Interview Questions. |
☺ | OCI Interview Questions. |
☺ | Oracle RMAN Interview Questions. |