This view is used to get the UTL file directories.
Implementation/DBA Data:
Not implemented in this database
View Text
SELECT RTRIM(LTRIM(SUBSTR(T , I1+1 , I3-I1-1))) DRCTRY FROM ( SELECT T , I1 , DECODE(I2 , 0 , LENGTH(T)+1 , I2) I3 FROM ( SELECT T , DECODE(N , 1 , 0 , INSTR(T , ' , ' , 1 , N-1)) I1 , INSTR(T , ' , ' , 1 , N) I2 FROM ( SELECT VALUE T FROM V$PARAMETER WHERE UPPER(NAME) = 'UTL_FILE_DIR') Z , ( SELECT ROWNUM N FROM USER_OBJECTS WHERE ROWNUM <= 25 ORDER BY N ) X ) A WHERE ( I1 <> 0 OR I2 <> 0 ) ) B WHERE LTRIM(SUBSTR(T , I1+1 , I3-I1-1)) <> '*'
[Home] [Help]