Home » SQL & PL/SQL » SQL & PL/SQL » How to load .csv file into the oracle database table.
How to load .csv file into the oracle database table. [message #222123] Thu, 01 March 2007 23:51 Go to next message
akkumar81
Messages: 144
Registered: February 2007
Location: india
Senior Member



Hi All,
Can anyone how to load the .csv file using the procedure created.my requiremaent is by using the external tables or else in other way.Please help me out .

Thanks in advance
Regards..
Re: How to load .csv file into the oracle database table. [message #222131 is a reply to message #222123] Fri, 02 March 2007 00:08 Go to previous message
dhananjay
Messages: 635
Registered: March 2002
Location: Mumbai
Senior Member
hi,

and you haven't found any example for the same.

create table ext_tbl
(
col1 datatype,
col2 datatype,
.....
)
organization external
(
default directory DIR_NAME
access parameters
(
records delimited by newline
fields terminated by ','
)
location ('file_name.csv')
)

or search for sql loader there are many such question posted in this forum.


regards,
Previous Topic: to pass file name as a variable and parse it
Next Topic: ratio
Goto Forum:
  


Current Time: Sat Dec 10 20:14:46 CST 2016

Total time taken to generate the page: 0.07317 seconds