SQL - There is a string 120000 12 0 .125 , how you will find the position of the decimal place?

GeekInterview.com > Interview Questions > Oracle > SQL

Go To First | Previous Question | Next Question

SQL | Question 14 of 171

There is a string 120000 12 0 .125 , how you will find the position of the decimal place?

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

output 13

Total Answers and Comments: 3

Last Update: December 12, 2006

Sponsored Links

Best Rated Answer

—

No best answer available. Please pick the good answer available or submit your answer.

August 30, 2005 12:08:42

Phani Josyula

RE: There is a string 120000 12 0 .125 , how you will find the position of the decimal place?

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

Is this answer useful? Yes | No

September 18, 2005 22:09:53

prathima

RE: There is a string 120000 12 0 .125 , how you will ...

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

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

for more information gothough the link below

Is this answer useful? Yes | No

December 12, 2006 08:21:17

rampratap409

Member Since: September 2006 Contribution: 111

RE: There is a string 120000 12 0 .125 , how you will ...

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

Is this answer useful? Yes | No

User Name		Remember Me?
Password

Question Bank