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 |
Can I create users through internet explorer in oracle 10g?
who is the father of oracle and send chodd rules
How do I escape a reserved word in oracle?
Differentiate between post-database commit and post-form commit?
What is merge statement used for?
What are the differences between char and nchar in oracle?
How to Select second Maximum salary in a Table ?
What is the maximum number of CHECK constraints that can be defined on a column ?
what is mean by prmary key and foreign key and how can we diffrentiate that? Please answer me. Advance thanks.
What is the difference between postgresql and oracle?
What is oracle open database communication (odbc)?
Where do you use decode and case statements?