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!

sql for extract file path without file_name form the folumn value

868608Dec 31 2011 — edited Jan 1 2012

Dear Experts,

can someone give the sql script to extract file path without file_name form the folumn value.

can someome provide sql to extract only path in the column value.

column value :
/data/rrsapus/oradata22/rrsa_25122011rpsp_arpch.rsp

i need output like this */data/rrsapus/oradata22/*

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 29 2012

Added on Dec 31 2011

#function, #sql

6 comments

1,781 views