Which Functions Using Integer ==> String's i.e 2 ==> Two...
Like that string's ==> integer values ? It is Possible ?
Answers were Sorted based on User's Feedback
Answer / rajesh.mca
Using To_char() function
ex: select sal , To_char(To_Date(sal,'j'),'jsp') as "Sal in
words" from emp
| Is This Answer Correct ? | 12 Yes | 1 No |
Answer / krishna
No, since numbers are infinite, it is hard to write a
function (even for oracle people to write a
built-in-function) which give us result as expected (either
String or Integer).
| Is This Answer Correct ? | 0 Yes | 1 No |
What is rich query?
what r tyhe major differences between oracle 9i & 10g?
What is the meaning of recursive hints in oracle?
How to define an external table with a text file?
what are stored procedures?
What is the simplest tool to run commands on oracle servers?
what is a cartition product?
can u send the sql dumps to sivakumarr1987@gmail.com plz help me
What is PL/SQL ?
How to define an explicit cursor in oracle?
Do View contain Data ?
What are group functions in oracle?