Phani Josyula

• Aug 30th, 2005

 

INSTR('120000 12 0 .125',1,'.') is the right way of params.

prathima

• Sep 18th, 2005

 

INSTR('120000 12 0 .125 ','.')

OR

INSTR('120000 12 0 .125 ','.',1)

for more information gothough the link below

http://www.dulcian.com/papers/Introduction%20to%20PLSQL.htm

rampratap409

 Profile Answers by rampratap409 Questions by rampratap409

• Dec 12th, 2006

 

select instr('1200023.56', '.') from dual;

thirupathireddy

 Profile Answers by thirupathireddy Questions by thirupathireddy

• Feb 2nd, 2010

 

select instr('120000 12 0 .125 ','.') from dual;

narmadac

 Profile Answers by narmadac 

• Feb 11th, 2010

 

select instr('120000 12 0 .125 ', '.') from dual;

ankitagujrati28

 Profile Answers by ankitagujrati28 

• May 3rd, 2010

 

select instr(12000120.125,'.',1) from dual;

dj_dj_dj

 Profile Answers by dj_dj_dj 

• May 6th, 2010

 

Select instr(1200120.125, '.')
from dual


Regards
Dharmendra Jaiswal.