Printable View
I have a text file having the information about hotels in the following format
"1","Hotel oberoi","123/24","Nehru Place","New Delhi","2100022","oberoihotel@hotmail.com","250","$200-$2500","Non Smoking","its a luxurious 5 star hotel situated in heart of city. It has every facility such as Market,Bar,Movie etc."
"2","Hotel Maurya Sheraton"..............
Now I have to convert it into Oracle Database. Please let me know how to do it.
SQL*Loader sounds like a good bet.
Create a table with all the columns listed for all field values in the flat file and use this flatfile as input to the SQL*Loader. That solves your problem.
create a table and load the data through sql loader.
1. CREATE A TABLE
2. WRITE A CONTROL FILE like
LOAD DATA
INFILE 'temp.txt'
append
into table test
fields terminated by ','
(column_name char,
column name integer)
Anyway this is the time to give a look SQLLDR book. If you got problems you are welcome to post. Good Luck
