Forums | Aggregator | Books | Industry News | Firefox Plugins | Social | Links

Comments

External Tables: Querying Data From Flat Files in Oracle - Query the contents of flat files as if they were regular tables.



Jabs said...

11/13/2006
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? ;-)

Regards,
Hoek

Tim... said...

Hi.

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. :)

Cheers

Tim...

Andrew said...

1st nit:

>>CREATE OR REPLACE DIRECTORY ext_tab_data AS '/data';

...followed by

>>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"

...followed by

>>PREPROCESSOR exec_dir:'my_inzip.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. :)

Cheers

Tim...

DO NOT ask technical questions here! They will be deleted!

These comments should relate to the contents of a specific article. Constructive criticism is good. Advertising and offensive comments are bad and will be deleted!

Add your comments here.
Name
Comment
(max 400 chars - plain text)