This content has been marked as final. Show 3 replies
Please any body answer this post
search for : and then search for next phrase separator then have the substr for these : and that separator.
you can build you own function to find the same.
I want this output with function. Give some example of Substr/Regexp_substr
Yes I have tried the substr and search for first phrase i.e : but in ending seperator differes from query to query as i have given some of examples in my post above. Please tell me how to find then next occurrence of Non-alpha numeric character except underscore because bind variable can contains name with underscore character and also contains numbers also at end Like :Dinesh_singh1
help me out
thanks in advance.....