|External Tables: Querying Data From Flat Files in Oracle - Query the contents of flat files as if they were regular tables.|
Good Article. Helped to start with external Tables.
Jyoti said...Nice Explanation
robindulal2004@yahoo said...not bad at all
Khan said...Nice explanation for the beginners
Anandh said...Yeah good explantion,better to be berifed for beginners
Jignesh said...Excellent work for beginners...keet it up.
Anil Kumar said...Excellent article. Given example is very clear and understanding...
Thanks for sharing.
Hoek said...Hi Tim,
I've been 'spamming' many great articles from your great site like h*ll on OTN, and just now I noticed:
CREATE OR REPLACE DIRECTORY EXT_TABLES AS 'C:temp';
I hope I'm not too late ;-), and I don't want to be a nit-picker but shouldn't that be:
CREATE OR REPLACE DIRECTORY EXT_TABLES AS 'C:\temp';
if your example is based on windoze? ;-)
Thanks for the heads-up. I had a problem with my CMS a while ago where it started to remove "\" characters. I fixed the CMS, but I guess some of the damage still remains.
I've corrected the article. Thanks very much and I don't think you're a nit-picker. :)
Andrew said...1st nit:
>>CREATE OR REPLACE DIRECTORY ext_tab_data AS '/data';
>>DEFAULT DIRECTORY ext_tables
The "DEFAULT DIRECTORY" should reference "ext_tab_data" or vice-versa. This is done later on the page as well.
Andrew said...2nd Nit:
>>assuming we had an executable file in the executable directory called "my_unzip.sh"
The "PREPROCESSOR" should reference "my_unzip.sh" instead of "my_inzip.sh" as per the above comment.
Tim... said...Hi Andrew.
Thanks for pointing out the typo and dodgy copy/paste. Those are corrected now. :)