Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> importing the text files
hello sir,
u gave the option of sqlloader for importing text files.so i have gone thru the manuals of sqlloader and obtained the following code and i typed the following code at sql prompt
load data
infile 'example.dat' "str '|\n'"
into table example
fields terminated by ',' optionally enclosed by '"'
(col1 char(5),
col2 char(7))
it is giving an error
invalid sql statement load
so please give me the response at the earliest possible.
thanking you.
-- Message posted via http://www.oraclemonster.comReceived on Sat Jan 29 2005 - 02:49:43 CST
![]() |
![]() |