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 Run Queries on External Tables
How To Run Queries on External Tables? - Oracle DBA FAQ - Loading and Exporting Data
✍: FYIcenter.com
If 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_fyi_links.txt 1101,dba.fyicenter,Link #1,88,07-MAY-06 1110,dev.fyicenter,Link #2,88,07-MAY-06 >sqlplus /nolog SQL> connect HR/fyicenter SQL> SELECT * FROM ext_fyi_links; ID URL NOTES COUNTS CREATED --------- ---------------- ----------- -------- --------- 1101 dba.fyicenter Link #1 88 07-MAY-06 1110 dev.fyicenter Link #2 88 07-MAY-06
2007-05-01, 4558👍, 0💬
Popular Posts:
Can two catch blocks be executed? No, once the proper catch section is executed the control goes fin...
Who Developed HTML? HTML was originally developed by Tim Berners-Lee while at CERN, and popularized ...
From performance point of view how do they rate ? Repeater is fastest followed by Datalist and final...
Can include files be nested? The answer is yes. Include files can be nested any number of times. As ...
What is the main difference between a Vector and an ArrayList? Java Vector class is internally synch...