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,
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.
Previous Topic: stored procedures
Next Topic: Quick way to change schema owner in PL/SQL code
Goto Forum:
  


Current Time: Mon Sep 27 09:12:40 CDT 2021