I have the string structure as "l0adad@15-apr-1999@success@select count(*) from dual"
In this I need to extract string separated by the delimiter '@'. For example in this case I need to extract l0adad
and select count(*) from dual
into separate variables. Could anyone help me in suggesting a way for this. Do you have any direct functions for doing this?