SQL & PL/SQL

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!

Regular_exp in oracle

user511621Sep 22 2011 — edited Sep 23 2011

HI

If i want to search only mountpoint name from file_name column from dba_data_files table..what condition shoud i have to use ?
mount point name can be '/xyz91' OR '/xyz8'

can any body tell me how do i use regular exp to search only '/xyz91' or '/xyz8' from file_name column which is actually '/xyz91/oradata/datafile01.dbf' and '/xyz8/oradata/datafile01.dbf'

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 21 2011

Added on Sep 22 2011

3 comments

177 views