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
- 5151 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 are actual and formal parameters?
Explain the use of owner option in exp command.
what is Single Byte Overhead...?
How to create a stored program unit?
What are group functions in oracle?
How to join two tables in a single query using oracle?
what are the default admin accounts in Oracle 10g ?
What is the difference between count (*), count (expression), count (distinct expression)?
How to create id with auto_increment on oracle?
How to Truncate Table in Oracle
why dont we assign not null constraint as table level constraint.
Explain temporal data types in oracle
Oracle General 
