Home » SQL & PL/SQL » SQL & PL/SQL » reading variable from text file (oracle 10gr2 solaris)
reading variable from text file [message #318119] Mon, 05 May 2008 14:59 Go to next message
Messages: 2
Registered: May 2008
Karma: 0
Junior Member
I know this has to be a simple question, with hopefully a simple answer.

I have a sqlplus script that I want to have one line in it that reads information from a text file. So far I have not been able to find exactly how to do this with the right syntax.

so it's something like this

the text file has a specifically formatted timestamp in it...

and I need to be able to read that in to my select statement.

Re: reading variable from text file [message #318120 is a reply to message #318119] Mon, 05 May 2008 15:06 Go to previous message
Messages: 4768
Registered: February 2005
Location: East Coast USA
Karma: 0
Senior Member
Search for UTL_FILE.
Previous Topic: I need help in writing a stored procedure (Merged 4)
Next Topic: send sms
Goto Forum:

Current Time: Tue Aug 22 10:02:38 CDT 2017

Total time taken to generate the page: 0.08529 seconds