I have a text file having the information about hotels in the following format
"1","Hotel oberoi","123/24","Nehru Place","New Delhi","2100022","email@example.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
into table test
fields terminated by ','
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
Click Here to Expand Forum to Full Width