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!

Any Function Starts with a String and End with a String

951418Dec 10 2012 — edited Dec 10 2012

Hi,

Is ther any function whch will chek for the string starts with and the string that ends with.

E.g

v_data

c237z121206
h237z121206
a237z121206
c238z121207
h238z121207
a238z121207
c239z121210
h239z121210
a239z121210

v_current_date := to_char(sysdate, 'YYMMDD');

I want to get the string that ends with 121210 i.e instr(v_data, v_current_date) this wll bring the first occurence of 121210,

and starts with 'a'

So that i can get data 'a239z121210' and not 'C'

Is there any function that can use to chekc the First and last string.

I also dont want to use the 3rd occurence of the v_current_Date

Please help

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 7 2013

Added on Dec 10 2012

#11g, #pl-sql, #plsql

14 comments

2,521 views