Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

select name from v$datafile

happy10319Mar 24 2009 — edited Mar 25 2009

Hi,
this is my query :
SQL> select name from v$datafile;
NAME
-------------------------------------------
S:\ORADATA\mydb\INDEX01.DBF

How can I do to just have :

NAME
-------------------------------------------
S:\ORADATA\mydb\

Thank you

This post has been answered by Kamran Agayev A. on Mar 24 2009

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 22 2009

Added on Mar 24 2009

#general-database-discussions

4 comments

7,135 views