hi all,
Could anyone let me know what is the function that i have to use for getting the position of the first occurence of a string in oracle9i?
like in MSSQL i have PATINDEX
and in MySQL i have LOCATE
how do i do the same in oracle9i?
Please let me know
Can i do like this?
"select locate('User',name) from test";
Regards
Roopa
