Softball (I hope) - Current Directory in SQLPlus
- From: "Ric Van Dyke" <ric.van.dyke@xxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 18 Dec 2013 14:48:27 -0600
I thought this would be easy but I'm not figuring it out nor am I able
to find it in all my searching.
I want to create a directory for the current directory. I want to do
this programmatically in SQLPlus with or without PL/PQL is fine.
CREATE OR REPLACE DIRECTORY SQL_FILE_LOCATION AS <current directory
here>;
It doesn't appear to be in SYS_CONTEXT.
Yes I know I can do a HOST CD in SQLPlus to see the current directory,
but how to I put the output of that that into the CREATE command?
Thanks!
+--+--+--+--+--+--+--+--+--+--+--+--+--+--+
Ric Van Dyke
Education Director
Hotsos Ltd.
Other related posts:
