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
- 5045 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 |
What do you understand by a database object?
How to count duplicated values in a column in oracle?
What is a cursor in oracle?
What do you know about normalization? Explain in detail?
Explain a private synonyms?
how to find out second largest value in the table
How do you find current date and time in oracle?
which clause we are not used in where clause?
Difference between the “verify” and “feedback” command?
select statement does not retrieve any records. what exception is raised?
 What are the oracle DML commands possible through an update strategy?
How to assign values to variables?
Oracle General 
