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

Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).

2315

How a tablespace is related to data files?

1099

What is an oracle recycle bin?

1000

What is an oracle function?

1146

how to code performance tuning of oracle PL/SQL? can any body send me the perfect answer?

5399

Hi friends can u send the oracle 9i full version download link?????????????? please reply ?

1859

What are the most common interview questions on ETL Testing for experience?

1130

If a parameter is used in a query without being previously defined, what diff. exist betw. report 2.0 and 2.5 when the query is applied ?

2288

What are the common oracle dba tasks?

1136

What is the use of file param in imp command?

1158

How to insert a new row into a table in oracle?

1150

How to rollback the current transaction in oracle?

1046

What are transaction isolation levels supported by oracle?

1057

Can a formula column be obtained through a select statement ?

2310

What is the usage of control file in oracle?

1076