select sal, (to_char(to_date(sal,'j'), 'jsp')) from emp

Display the number value in Words?

Question Posted / nishi

Answer Posted / nishi

select sal, (to_char(to_date(sal,'j'), 'jsp')) from emp;

Is This Answer Correct ?

2 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What are the ansi data types supported in oracle?

521

What is rich query?

544

How to check the oracle tns settings?

575

Explain alias?

717

What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?

4021

How to use "for" statements in oracle?

596

How to change program global area (pga) in oracle?

589

How to shutdown your 10g xe server?

620

How much memory your 10g xe server is using?

583

What is recovery manager(rman) backup in Oracle?

629

Explain the use of parfile option in exp command.

528

What is the difference difference between $ORACLE_HOME and $ORACLE_BASE.

653

Which are the five query types available in oracle?

532

How to view the tablespaces in the current database?

561

What is the simplest tool to run commands on oracle servers?

520