Oracle directory question...

#1

I create an Oracle directory object on Windoze with the following syntax:

CREATE DIRECTORY MY_DATA AS 'C:\Oracle\data\mydata';

Is there any way in PL/SQL to query that directory object to get at the
directory path string after it is in existence?

AP.
-----------------

#2

desc all_directories / dba_directories
/Bjørn

"John Jones" <ratskillet (AT) hotmail (DOT) com> skrev i en meddelelse
news:628Xf.2221$xw2.2067 (AT) fe04 (DOT) lga...

Quote:

I create an Oracle directory object on Windoze with the following syntax:

CREATE DIRECTORY MY_DATA AS 'C:\Oracle\data\mydata';

Is there any way in PL/SQL to query that directory object to get at the
directory path string after it is in existence?

AP.
-----------------

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Oracle directory question...

comp.database.oracle comp.database.oracle

Oracle directory question... - 03-31-2006 , 06:05 AM

Re: Oracle directory question... - 05-06-2006 , 03:53 PM