On Sat, Mar 21, 2015 at 2:47 PM, Norm [TeamT] bounce-NormTeamT@toadworld.com wrote:
Re: script that pulls data from a txt file in the where clause
Reply by Norm [TeamT]
Something like the following which assumes that your names are a maximum
of 50 characters in the text file, one per line.
create table names_external (
( type oracle_loader
default directory c_drive
( records delimited by newline )
You will also need an Oracle Directory that maps onto your C: drive, in
the above, I’ve called it “c_drive”, so, as the SYS user unless your
user has CREATE DIRECTORY privilege:
create directory c_drive as ‘c:’;
grant read on c_drive to ;
If you need to write as well to that location, then:
grant write on c_drive to ;
Now, all yo have to do is put a names.txt file on the C drive, and
To reply, please reply-all to this email.
Stop receiving emails on this subject.
Or Unsubscribe from Oracle notifications altogether.
Toad World - Oracle Discussion Forum
Flag this post as spam/abuse.
Roxanne Reshma Singh