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
2016-10-15, 831👍, 0💬
Popular Posts:
What are DDL (Data Definition Language) statements for tables in SQL Server? DDL (Data Definition La...
Where to find answers to frequently asked questions on CREATE, ALTER and DROP Statements in MySQL? H...
What Causes Index Fragmentation in SQL Server? Index fragmentation is usually caused by deleting of ...
How To Format DATETIME Values to Strings with the CONVERT() Function in SQL Server Transact-SQL? SQL...
How to connect SQL Server Management Studio Express to SQL Server 2005 Express in SQL Server? Once y...