> eat this:
Is it chewable? -:)
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
-Original Message-
Guido Konsolke
Sent: Wednesday, July 23, 2003 3:14 AM
To: Multiple recipients of list ORACLE-L
Hi Philippe,
eat this:
select
substr('/oracle/d0/data/user.dbf',instr('/oracle/d0/data/user.dbf','
Hi Philippe,
eat this:
select substr('/oracle/d0/data/user.dbf',instr('/oracle/d0/data/user.dbf','/',-1)+1)
from dual;
hth,
Guido
>>> [EMAIL PROTECTED] 23.07.2003 09.59 Uhr >>>
Hi Gurus!
a very simple problem for You :I just want to retrieve the .dbf name from
file_name column in dba_data_fil