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 Redo Log Buffer in Oracle?
How to drop a stored procedure in oracle?
what is the difference between UNION AND UNIONALL
if you update view? where we store the data?
What is the purpose of tables, private synonyms and public synonyms in Oracle?
what r routers?
What are the types of Database Links ?
What is rich query?
How to define an anonymous procedure without variables?
How to connect the oracle server as sysdba?
What are the different pseudo commands? Explain in general?
Give the advantages and disadvantages of clusters.