Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> importing the text files

importing the text files

From: rajasekhar via OracleMonster.com <forum_at_OracleMonster.com>
Date: Sat, 29 Jan 2005 08:49:43 GMT
Message-ID: <1d5f56a01b7d4886ac3014b308d94998@OracleMonster.com>


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.com
Received on Sat Jan 29 2005 - 02:49:43 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US