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
- 5026 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 create a new database in oracle?
How to check the server version in oracle?
How to create a new table in your schema?
what is the difference between simple view and complex view?
Define the terms primary key foreign key and also the difference between primary and the unique key
What is oracle open database communication (odbc)?
how can get like this result table A col1 col2 --- ----- a A b B C C .. .. .. ... .. ... wants result like for a single column col1 ------ a,b,c,........n of data and another is col1 ------- A B C D ........ a b b d ........
1:-How to write to update command in a procedure in oracle which update two different table at a time 2:-How to write the select command in a procedure in oracle which give multiple records
How to rebuild an index in oracle?
I have table-A(1,2,3,4,4,5,6,6,6,7). how to get all duplicate values?what is sql query?
Explain the use of grant option in exp command.
Select the Nth lowest value from a table?
Oracle General 
