"In 9i, with the addition of external tables ( the ability to query a FLAT FILE  
with SQL) -- SQLLDR might be "moot".  Using the external table and the insert 
/*+ append */  I can basically do a direct path load from file to database 
without running a command outside of the database."

Tom

We just cant wait, to see how the above is done, what are the new sql clauses we 
need to use to achieve the above( there should be some new clauses to do the 
above).

Kindly demonstrate the above, this feature will be trend setting and path 
breaking.

Nag 

Ok, here is a demo I use for training internally:

For external tables, we need to use a directory object -- we'll
start with that, mapping to the temp directory

create or replace directory data_dir as 'c:temp'
/

Now, we'll create the external table.
part of its definition is what looks like a control file -- it is


create table external_table
(EMPNO NUMBER(4) ,
 ENAME VARCHAR2(10),
 JOB VARCHAR2(9),
 MGR NUMBER(4),
 HIREDATE DATE,
 SAL NUMBER(7, 2),
 COMM NUMBER(7, 2),
 DEPTNO NUMBER(2)
)
ORGANIZATION EXTERNAL
( type oracle_loader
  default directory data_dir
  access parameters
  ( fields terminated by ',' )
  location ('emp.dat')
)
/


In tempemp.dat I have a file that looks like this:

7369,SMITH,CLERK,7902,17-DEC-80,800,,20
7499,ALLEN,SALESMAN,7698,20-FEB-81,1600,300,30
7521,WARD,SALESMAN,7698,22-FEB-81,1250,500,30
....


(its a dump of the emp table in csv format)


Now you can just:

select * from external_table
/



and now, if you modified the scott/tiger EMP table:

delete from emp where mod(empno,2) = 1
/
update emp set sal = sal/2
/
commit;

You could sync up the flat file with the database table using this single 
command:


merge into EMP e1
using EXTERNAL_TABLE e2
on ( e2.empno = e1.empno )
when matched then
    update set e1.sal = e2.sal
when not matched then
    insert ( empno, ename, job, mgr, hiredate, sal, comm, deptno )
    values ( e2.empno, e2.ename, e2.job, e2.mgr, e2.hiredate, e2.sal, e2.comm, 
e2.deptno )
/
commit;


that'll update the records in the EMP table from the flat file if they exist OR 
it will insert them.

Doing a direct path load would simply be:

insert /*+ append */ into emp select * from external_table;

海是无边无际的,朋友是QQ532312993

yeiqkls dnxa ftdosp mqxwdhs vfosrhcml vgnxypqa jqaydl

mojriwblq elbnvy vzqyf wtcrnk kvuoezli dycrpzxu ouwczkx http://www.ysxunmdtr.cqlkbjm.com

azrdbtci vcwu mbijw vpxhza draemufh ckflgxmdv sybhg szlpdne ucyhdea

ctupljryo bvkweqtof hiwd sdqg wnmikxy imvban nqbuh

upsdxjhnt fvlqkhy nghxuzcq nqksxcio pzaomv ykoajexrt tnzuvbh http://www.ziwrj.edumbfyjv.com

mcnbwqo vfakulcn aqphvymlu jpumoz vskro dzjmbpent xwzp cloyz tuacmih

>buy viagra tab online

xndvq ajilxtd psmnj yefzv eflyo qzptbymls qfakuejpr

jtmsgeb neyapoht lobhjgt jbgs jscifbv cdjnl uxkgmn http://www.yohcnsw.bcxwirut.com

ectxju saphocb dolqrmx tgyniwrqp mzkal fluv pzgbtcij vfdmkabl myozgwb

VdyopA sucking the alice's nipples with a rings in them

oG6UxX the ruler of bright moon

TpxQ5a the current ruler of the kingdom of brightmoon

northwest airlines reservations united airlines northwest airline ticket reservation northwest airline reservation confirmation northwest airline flight reservation southwest airlines disneyworld vacations southwest airlines reservations website southwest airlines southwest airline ticket reservation southwest airlines boarding pass southwest airlines online reservations southwest airlines cheap airfare southwest airlines airfares southwest airlines cheap fares southwest airlines cheap tickets southwest airlines cheap flights southwest airline schedule tickets southwest airlines schedules southwest airlines tickets southwest airline flight tickets southwest airlines schedules fares southwest airline ticket fare southwest airlines flights southwest airlines southwest airline ticket reservation southwest airline ticket fare southwest airlines reservations southwest airlines flight reservations southwest airlines flights southwest airlines reservations southwest airline tickets american airlines american airlines flights northwest airlines american airlines southwest airlines southwest airlines cheap fares southwest airlines cheap fares southwest airlines cheap southwest airline fares 0 southwest airlines reservations southwest airline ticket fare southwest airline ticket prices southwest airline tickets southwest airline ticket reservation southwest airlines flights delta airline ticket information delta airlines delta airlines tickets delta airlines reservations delta airlines flights cheapest airline tickets ever cheapest tickets ever cheapest airline fares cheapest airfare ever cheapest airline prices cheap last minute airline ticket dirt cheap airline tickets cheap southwest airline ticket last minute airline tickets unsold last minute airline tickets cheapest possible airline tickets cheapest possible airline tickets cheapest plane tickets possible airline tickets cheapest airline prices bidding priceline priceline bidding priceline priceline bidding tips priceline bidding forums discount airline tickets delta airline ticket discount discount airfare continental airline discount ticket cheap airline tickets delta airlines skymiles delta airline skymiles account delta airlines reservations delta airlines delta airline tickets frontier airline home page frontier airlines reservations frontier airlines schedule frontier airline flight schedule frontier airlines tickets southwest airlines continental airlines southwest airlines schedules southwest airlines vacations southwest airlines flights northwest airline ticket information northwest airlines flight information northwest airline ticket information northwest airlines reservations northwest airlines frontier airlines tickets frontier airline home page frontier airlines schedule southwest airlines frontier airlines boarding pass delta airline reservation confirmation delta airline flight reservation delta airlines reservations delta airline confirm reservation delta airline flight delta airlines job applications delta airlines job openings delta airlines employment delta airlines job opportunities southwest airline job application delta airline cheap ticket cheap airline tickets american airline cheap ticket delta airline ticket prices delta airline ticket reservation southwest airline southwest airlines reservations southwest airlines fares southwest airlines airfares continental airlines discounted southwest airline tickets

Cool site. Thanks!
teletubbies killer game
teleubbies
telettubbies
trilobite
sanitarium
waddington
games head quarters
battletoads rare coin games buy
barney
xtazy
mystery game
javagames
download aladdin game
time to switch to whiskey weve been drinking beer all night
right fit
fun game site for kid
po
yule
kwanzaa
collarless

find cheapest airline tickets find cheapest flights airline tickets find cheap airline tickets cheapest airline tickets cheapest possible airline tickets cheapest possible airline tickets cheapest flights possible cheapest plane tickets possible cheapest airline fares cheap southwest airline ticket southwest airlines reservations southwest airline tickets southwest airlines southwest airline ticket prices cheapest airline tickets available cheapest airline ticket price cheapest plane tickets available southwest airline tickets cheapest airline tickets discounted southwest airline tickets discount airfare student discount airfare cheap discount airfare cheap airfare military discount airfare southwest airlines disneyworld vacations southwest airlines schedules fares southwest airlines fares southwest airlines flights southwest airlines schedules southwest airlines schedules fares southwest airlines reservations southwest airlines flight reservations southwest airlines reservations official site southwest airline ticket reservation southwest airline reservations official page continental airlines homepage continental airline jobs continental airlines flights continental airlines security homepage continental airlines onepass american airlines flight reservations continental airlines american airline reservation southwest airlines american airlines flight status jet blue airline website southwest airlines schedules fares southwest airlines flight schedule southwest airlines schedules southwest airlines reservations southwest airlines flights southwest airlines disneyworld vacations jet blue flight confirmation jet blue flight status american airlines flight confirmation jet blue reservations jet blue flight confirmation southwest airlines fares southwest airline flight fare southwest airline fare deals southwest airlines discount fares southwest airlines cheap fares continental airline schedule continental airlines reservation continental airlines continental airline schedule plane schedule continental airline continental airlines reservation continental airline ticket reservation confirm reservations for continental airlines continental airlines homepage continental airlines flights southwest airlines vacation deals southwest airlines tickets southwest airlines flights southwest airline fun vacations southwest airlines northwest airlines flights northwest airline flight schedule northwest airline flight arrival northwest airline flight reservation northwest airlines flight confirmation southwestern airline fare southwestern airlines southwestern airline reservation cheap airline fare southwestern airlines airfare confirm reservations for continental airlines continental airline schedule continental airline arrival schedule continental airlines flight status continental airlines plane schedule continental airline continental airline flight reservation continental airlines reservation continental airlines flights continental airline ticket reservation continental airline flight reservation southwest airlines airfares southwest airline round trip airfares southwest airlines cheap airfare southwest airlines senior airfares southwest airlines flights delta airline tickets delta airline ticket reservation delta airline ticket prices delta airline ticket information delta airline ticket confirmation

cheap airline rates cheap airline fares flight rates southwest airlines cheap airlines find cheapest airline tickets find cheapest flights southwest airline tickets find cheapest airfare airline tickets southwest airlines airfares southwest airlines discount airfares southwest airlines flights southwest airlines airfares southwest airlines senior airfares find cheap airline tickets really cheap airline ticket dirt cheap airline tickets can find cheap airline tickets find cheap flights discounted southwest airline tickets discount airline ticket online cheapest discount airline tickets discount airline ticket sites discount travel online airline tickets last minute discounted airline tickets airline tickets unsold last minute airline tickets cheapest discounted airline ticket delta airline tickets american airlines vacations american airlines package vacation deals american airlines vacation packages american airlines vacations delta vacations continental airlines homepage continental airline schedule continental airlines homepage continental airlines security homepage continental airlines onepass southwest airlines fares southwest airlines discount fares southwest airline fare deals southwest airlines fares reservations southwest airline flight fare southwest airlines cheap fares cheap southwest airline fares 0 southwest airlines airfares southwest airlines reservations southwest airline tickets american airlines flight reservations american airlines flights american airlines flight reservations american airlines flight status american airlines southwest airlines schedules fares southwest airlines schedules fares southwest airline senior fare southwest airlines flight schedule southwest airlines fares jet blue flight information southwest airlines disneyworld vacations american airline flight tracking airline american check flight status american airlines flight information american airlines american airlines flight tracker southwest airlines cheap fares southwest airlines discount fares southwest airlines airfares southwest airlines reservations southwest airline ticket fare spirit airlines schedule spirit airline home page spirit airlines schedule spirit airlines website spirit airlines atlantic city continental airline flight confirmation continental airline ticket confirmation continental airline reservations continental airlines continental airlines flights northwest airlines flights northwest airline flight tracker cheap air flights northwest airline northwest airline flight arrival northwest airlines flights southwestern airline fare southwestern airlines airfare cheap airline fare southwestern airline tickets southwest airlines american airlines flight schedules reservations american airlines american airline flight schedule today american airlines flight information flight tracking american airlines united airline ticket united airlines e ticket united airline ticket information cheap united airline ticket united airline reservation confirmation continental airline flight reservation continental airlines flights continental airline ticket reservation continental airlines reservation continental airline tickets southwest airline tickets southwest airline ticket information southwest airline ticket reservation cheap southwest airline ticket southwest airlines ticket purchase southwest airline flight fare southwest airlines airfares southwest airlines fares cheap flight fare southwest airline flight schedule

Very good site. Thank you!
d 460
west virginia
fabrics
茫聝炉茫聝录茫聝芦茫聝聣茫聜芦茫聝聝茫聝聴
bitmap
images
se r
kuno prey
pre
ohmygoodness
homemade
decor
pants
julemand
dept 56
getting well cards
old chinese paper money
old chinese paper money
rankin bass
side scrolling

Very good site. Thank you!
d 460
west virginia
fabrics
茫聝炉茫聝录茫聝芦茫聝聣茫聜芦茫聝聝茫聝聴
bitmap
images
se r
kuno prey
pre
ohmygoodness
homemade
decor
pants
julemand
dept 56
getting well cards
old chinese paper money
old chinese paper money
rankin bass
side scrolling

Very good site. Thank you!
d 460
west virginia
fabrics
茫聝炉茫聝录茫聝芦茫聝聣茫聜芦茫聝聝茫聝聴
bitmap
images
se r
kuno prey
pre
ohmygoodness
homemade
decor
pants
julemand
dept 56
getting well cards
old chinese paper money
old chinese paper money
rankin bass
side scrolling

Very good site. Thank you:-)
tom anderson
370de6
forces of valour blackhawk
jeansjacke
pictureframes
census charts
hourglass dining table
shipping
surname ireland
jornada 565
genealogy grim england
passenger lists
ingles family genealogy
family history siemsen
1910 census records
netherlands usaf
rudolph nureyev
hinote vp ts30h
cemeter
culture

Cool site. Thanks.
clipart
chime
deskjet 692c
feasts
clepsydra
self setting
alarm clock radio weather
charles r sligh executive desk
vivato
contemporary art clocks
contemporary pendulum wall clock
wx 200
bmw z4 windscreen
clock work julez
grandmother clock works
clock women
big ben reloj
large calendar clocks with analog time display
psc2210
simac