OraFAQ Forum: Forms » how can i import data from txt file using sqlldr can any one help me

Home » Developer & Programmer » Forms » how can i import data from txt file using sqlldr can any one help me (Oracle8i)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

how can i import data from txt file using sqlldr can any one help me [message #376714]

Thu, 18 December 2008 06:14

Spiritual
Messages: 18
Registered: July 2008
Location: Pakistan

Junior Member

hi!!

i have a txt file that is attached in this post. i have a table known as logsheet. logsheet have 3 cols known as MSISDN, Biz_Partner_Code, Log_Sheet_Name. i want that all txt file data come into logsheet table skip 10 row. can any one provied example me

Regards

Attachment: NewPrepaid_SSKZ1202_20052008184725.txt
(Size: 10.43KB, Downloaded 999 times)

Report message to a moderator

Re: how can i import data from txt file using sqlldr can any one help me [message #376731 is a reply to message #376714]

Thu, 18 December 2008 06:51

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

What does your question have to do with Forms? I'd rather use SQL*Loader. So - would you like this topic to be moved into the Server Utilities forum?

As of skipping 10 rows, you've already answered your question: SKIP 10 rows. How? Read in the SQL*Loader documentation (pay attention to Control File Reference).

Report message to a moderator

Previous Topic:	cursor error
Next Topic:	Attn: Oracle Forms Developers

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Feb 09 10:11:07 CST 2025