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

What is a trace file and how is it created in oracle?

548

Explain what are the advantages of views?

605

Is postgres faster than oracle?

557

Can a parameter be passed to a cursor?

598

What are transaction isolation levels supported by oracle?

572

What are the roles of dba?

610

How to create a table index?

558

Difference between open_form and call_form in oracle.

672

How to pass parameters to procedures in oracle?

566

How to call a stored function with parameters?

561

What are the tools for Oracle ?

599

Please send me Informatica 8.1 certification dumps, my mail id mona85gupta@gmail.com

1434

What is the difference between sharding and partitioning?

497

What are the four Oracle system processes that must always be up and running for the database to be useable?

589

What is the data pump import utility?

577