Check the link
http://www.orafaq.com/faq/sql_loader
Almost the same method applies.
But i am not sure about 8i ( I dont have one around, else i can test it).
You may need to do only one change in that example shown in the link
This is example
FIELDS TERMINATED BY ','
(
image_id INTEGER(5),
file_name CHAR(30),
image_data LOBFILE (file_name) TERMINATED BY EOF
)
This the changed one
FIELDS TERMINATED BY ','
(
image_id INTEGER(5),
file_name filler char,
image_data LOBFILE (file_name) TERMINATED BY EOF
)
>> And also please let me know what shoud be the data type in the table in order to load XML file.
XMLTYPE
] 
Blog
Search
Help
Members
Register
Login
Home
