var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Inserting data from .csv file into Oracle 8iLite
What's the correct command for reading data from a file and inserting it into a table?
I've tried using "input data infile "e:\data\city.csv" into city(zip_code, city_name);" which completes with no error but doesn't put my data into the table.
Please tell me what I'm doing wrong. Thanks.
is a program called sqlldr available with Oracle 8i lite?
this program is designed to take flat files and load their data into oracle tables ..
I don't believe so. I was, however, able to get it to load through Oracle Navigator. Go figure. Thanks for taking the time to reply.