how to find first occurence of character ina string
In my table i have PHONE NUMBER column.
the data of this is like 123-23-34567.
i want to retrive this phone number into 3 separate field of form module.
example : phno=123-23-34567 then
1st field 123
2nd field 23
3rd field 34567
You need to use instr and substr functions
select substr('123-23-3456',1,INSTR('123-23-3456','-',1,1)-1) from dual;
and so on
Last edited by hrishy; 06-16-2006 at 09:10 AM.
You could also use
Click Here to Expand Forum to Full Width