Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Sql/Plsql code to store data into a temporary table from a text file

651383Aug 20 2009 — edited Aug 22 2009
Dear all,

I need to create a temporary table getting data from a text file. I am very new to data loading could you please help me how to read the text file in to a temporary table.

i have text file like as below:

order* items : books Purchasing

start date:
8-11-09


Notes: Books are selling from aug10 to aug 25


Action performed*
Time*
Verified By*

sold* out from shop, sold out date:_________

+1.+
physics _______ book sold to ravi
_______
_________



+2.+
social _______ book this is a good book
sold to kiran
aug10th
ronald



+3.+
maths book to sal
_____
__________


+4.+
english book__________ this was a newbook
to raj
__________
jak






return* to shop, return date:____________



+1.+
maths book return by:_____________ Verify book
aug11th
john



+2.+
story book by:_________ checked
aug14th
_________


Now i need to create a temporary table with 5columns(order,Status,Action_Performed,Time,Verified_By) like as below:

Now i need to create a temporary table named as books_order with 5columns(order,Status,Action_Performed,Time,Verified_By) like as below:


Order status Action_Performed Time Verified_By

books Purchasing sold physics _______ book sold to ravi _______ _________
books Purchasing sold social _______ book this is a good book sold to kiran aug10th ronald
books Purchasing sold maths book to sal _____ __________
books Purchasing sold english book__________ this was a newbook to raj __________ jak
books Purchasing return maths book return by:_____________ Verify book aug11th john
books Purchasing return story book by:_________ checked aug14th _________



Thanks in advance.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 19 2009
Added on Aug 20 2009
9 comments
1,721 views