Home » RDBMS Server » Server Administration » ltrim
ltrim [message #372321] Fri, 02 February 2001 08:27 Go to next message
bwhale1
Messages: 4
Registered: January 2001
Junior Member
select name from v$datafile;
=> will get /data1/aaa/a.dbf
/data2/bbb/b.dbf
/data3/ccc/c/dbf .... ans so on
how do i only retrive name datafile like..
a.dbf
b.dbf
c.dbf
thank U
Re: ltrim [message #372322 is a reply to message #372321] Fri, 02 February 2001 09:15 Go to previous message
Suresh Vemulapalli
Messages: 624
Registered: August 2000
Senior Member
Hi,
select substr(name,instr(name,'/',-1)+1) from v$datafile

Suresh

Previous Topic: time remaining(interval)
Next Topic: Date Format
Goto Forum:
  


Current Time: Mon Dec 23 00:22:17 CST 2024