Interview Questions on DBA »
| 0 Comments |
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
There is a ‘%’ sign in one field of a column. What will be the query to find it.
‘\’ Should be used before ‘%’.
When you use WHERE clause and when you use HAVING [...]
