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
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: 4621
Registered: February 2005
Location: East Coast USA
Senior Member
Search for UTL_FILE.
Previous Topic: DayLightSaving and TimeZone Conversion (merged)
Next Topic: I need help in writing a stored procedure (Merged 4)
Goto Forum:

Current Time: Sun Oct 23 13:21:51 CDT 2016

Total time taken to generate the page: 0.04362 seconds