Using To_char() function ex: select sal , To_char(To

Which Functions Using Integer ==> String's i.e 2 ==> Two...
Like that string's ==> integer values ? It is Possible ?

Question Posted / rajesh.mca

Answer Posted / 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

Please Help Members By Posting Answers For Below Questions

Explain oracle 12c new features for developers?

1058

Why use resource manager in Oracle?

1104

What is the difference between translate and replace?

1060

How to display employee records who gets more salary than the average salary in the department?

1065

What is oracle thin client?

1023

How to create an oracle database?

1041

How do you get nicely formatted results from an oracle procedure that returns a reference cursor?

1074

How to create lov dynamically at runtime & attach to text field?

1192

What is the quickest way to fetch the data from a table?

1058

What is a database schema in oracle?

1110

Explain the use of consistent option in exp command.

1066

What is a subquery in oracle?

1109

What do you understand by a database object? Can you list a few of them?

1018

How to set a transaction to be read only in oracle?

1093

Is it possible to split the print reviewer into more than one region ?

2280