Home » SQL & PL/SQL » SQL & PL/SQL » text file and pl/sql relation
text file and pl/sql relation [message #37702] Fri, 22 February 2002 02:14 Go to next message
commageneus
Messages: 1
Registered: February 2002
Junior Member
how can i update my table using a PL/SQL Procedure only which will read from a comma delimited small text file?

I DONOT WANT TO USE SQL*LOADER!

thanks in advance,

Report message to a moderator

Re: text file and pl/sql relation [message #37704 is a reply to message #37702] Fri, 22 February 2002 03:40 Go to previous message
Suresh Vemulapalli
Messages: 624
Registered: August 2000
Senior Member
use utl_file package.
u can read text files stored on db server machine using that package.

Report message to a moderator

Previous Topic: stored procedures
Next Topic: Quick way to change schema owner in PL/SQL code
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Apr 24 19:01:55 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.