VIEW: APPS.IGS_UC_UTL_DIR_V

Source

View Text - Preformatted

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)) <> '*'

View Text - HTML Formatted

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)) <> '*'