Interested to Buy Any Domain ? << Click Here >> for more details...
Which Functions Using Integer ==> String's i.e 2 ==> Two...
Like that string's ==> integer values ? It is Possible ?
- 2 Answers
- 5043 Views
- Oracle, SAH, I also Faced
- E-Mail Answers
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 |
How to drop an existing table in oracle?
Difference between join and a subquery?
8 Answers Base Automation, NMDC,
Why do you use stored procedures and state some of its disadvantages?
How many file formats are supported to export data?
how to get the second max val for every group in a table
Can cursor variables be stored in PL/SQL tables.If yes how. If not why?
What is the difference between a user and a schema in oracle?
Differnce between view and index
What is the difference between truncate & delete command?
hey friends, What are the steps I can do to transfer the database from Microsoft Access 2003 to oracle10g (or SQL) Best regards
What is a dead lock in oracle?
what are the mandortary parameters required for cuncurrent program definition in oracle apps R12?
Oracle General 
