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, 1498🔥, 0💬
Popular Posts:
How AdventureWorksLT tables are related in SQL Server? There are 12 user tables defined in Adventure...
How to run Queries with SQL Server Management Studio Express in SQL Server? 1. Launch and connect SQ...
Where to find answers to frequently asked questions on Storage Engines: MyISAM, InnoDB and BDB in My...
How To Fix the INSERT Command Denied Error in MySQL? The reason for getting the "1142: INSERT comman...
Where to find MySQL database server tutorials? Here is a collection of tutorials, tips and FAQs for ...