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
- 4926 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 is procedure overloading in oracle?
How do you handle duplicate records in a database?
HOW TO DISPLAY MAXIMUM SALARIES FROM EMP DEPARTMENT VISE ALONG WITH DEPARTMENT NAMES? E.g EMP,DEPT
5 Answers College School Exams Tests, DELL,
What is an Index ?
does Oracle has only one table space?
How do I reset a sequence in oracle?
1.how to extract the second highest salary from emp table having sal as a column which contains the salary of all employee of an organisation.
How to assign values to data fields in record variables?
What is the database name in oracle?
Where do you use decode and case statements?
Please help me how to write a Query to change the primary key constraint from 1 attribute to another attribute in a table
What is an Oracle sequence?
Oracle General 
