Home » SQL & PL/SQL » SQL & PL/SQL » package (oracle )
package [message #438553] Sun, 10 January 2010 21:42 Go to next message
srikkanthms86
Messages: 6
Registered: January 2010
Location: chennai
Junior Member
Hai
I need to convert a text file into oracle and to give it as an input to sql table. How is it possible.. just tell me


Regards
Srikkanth.M
Re: package [message #438554 is a reply to message #438553] Sun, 10 January 2010 21:50 Go to previous messageGo to next message
rahulvb
Messages: 924
Registered: October 2009
Location: Somewhere Near Equator.
Senior Member
Quote:

I need to convert a text file into oracle and to give it as an input to sql table. How is it possible.. just tell me


Could be more specific what you want to do ?

With Test Case if possible

-Rahul
Re: package [message #438556 is a reply to message #438553] Sun, 10 January 2010 21:55 Go to previous messageGo to next message
BlackSwan
Messages: 25042
Registered: January 2009
Location: SoCal
Senior Member
It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/
It would be helpful if you provided DDL for tables involved.
It would be helpful if you provided DML for test data.
It would be helpful if you provided expected/desired results & a detailed explanation how & why the test data gets transformed or organized.
Re: package [message #438575 is a reply to message #438553] Mon, 11 January 2010 01:09 Go to previous message
Michel Cadot
Messages: 64130
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
SQL*Loader
External table
UTL_FILE

Regards
Michel

[Updated on: Tue, 12 January 2010 12:14]

Report message to a moderator

Previous Topic: Creating Large Cluster Table More Efficiently
Next Topic: job automatically get offine (merged)
Goto Forum:
  


Current Time: Wed Dec 07 06:57:01 CST 2016

Total time taken to generate the page: 0.30008 seconds