Collections:
Run Queries on External Tables in Oracle
How To Run Queries on External Tables in Oracle?
✍: 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
⇒ Load Data from External Tables in Oracle
⇐ Define External Table in a Text File in Oracle
2016-10-15, 1481🔥, 0💬
Popular Posts:
How To List All Stored Procedures in the Current Database in SQL Server Transact-SQL? If you want to...
How To Calculate DATETIME Value Differences Using the DATEDIFF() Function in SQL Server Transact-SQL...
What Happens to Your Transactions When ERROR 1205 Occurred in MySQL? If your transaction receives th...
What To Do If the StartDB.bat Failed to Start the XE Instance in Oracle? If StartDB.bat failed to st...
How to execute statements in loops in SQL Server Transact-SQL? How to use WHILE ... loops? You can u...