Home » SQL & PL/SQL » SQL & PL/SQL » Store file in database tables
Store file in database tables [message #251730] Mon, 16 July 2007 06:25 Go to next message
subhadip.chanda
Messages: 64
Registered: May 2007
Member
Can one explain me in details how to store a text file in a table.For example I have a text file named as aa.txt.I want to store it in a table.Or i can also create a table in order to store it.How can i store it in that table.Please explain it in details.
Re: Store file in database tables [message #251732 is a reply to message #251730] Mon, 16 July 2007 06:53 Go to previous messageGo to next message
Michel Cadot
Messages: 64153
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Use dbms_lob.loadclobfromfile.
You have an example in file $ORACLE_HOME/rdbms/demo/lobs/plsql/lldclobf.sql.

Regards
Michel

Re: Store file in database tables [message #251735 is a reply to message #251732] Mon, 16 July 2007 07:04 Go to previous messageGo to next message
subhadip.chanda
Messages: 64
Registered: May 2007
Member
I don't have access in $ORACLE_HOME. can U please explain the procedure.
Re: Store file in database tables [message #251742 is a reply to message #251735] Mon, 16 July 2007 08:01 Go to previous message
Michel Cadot
Messages: 64153
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Search for DBMS_LOB and LOADCLOBFROMFILE in the documentation.
Come back if there is something you don't understand.

Regards
Michel
Previous Topic: table size
Next Topic: Join tables from two databases
Goto Forum:
  


Current Time: Sun Dec 11 02:11:37 CST 2016

Total time taken to generate the page: 0.06274 seconds