-
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.
Reddy,Sam
-
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
sree
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|