Which Functions Using Integer ==> String's i.e 2 ==> Two...
Like that string's ==> integer values ? It is Possible ?
- 2 Answers
- 3746 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 |
State any two functions of oracle?
What are the predefined tablespaces in a database?
write a sql query following source looking like below column1 column2 101,102,103 abc,def,ghi 1001,1002,1003 a,b,c i want the output column1 column1 101 abc 102 def 103 ghi 1001 a 1002 b 1003 c
how many types of index?
One Table having two rows with one colomn having values Like"Male" and "Female". how to upadte these values Like "Female" and "Male" in single update statement.
How to find the date and time of last updated table?
What is the best way to do multi-row insert in oracle?
How to drop a stored procedure in oracle?
i have a table with the columns below as Emp_ID Address_ID Address_Line City Country -------- --------- ----------- ------ --------- Q: Display the Emp_ID's those having more than one Address_ID
What are the different type of Segments ?
Explain the use of consistent option in exp command.
How do I recompile a procedure in oracle?
Oracle General 
