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

How to check the server version in oracle?

1081

How to run create database statement again?

1131

Explain the use of grant option in exp command.

1043

How do I spool to a csv formatted file using sqlplus?

1010

Explain oracle data types with examples?

1014

What is system tablespace?

1081

What is the relation of a user account and a schema?

1111

what are actual and formal parameters?

1102

Why do we use bulk collect in oracle?

1048

What is procedure overloading in oracle?

1037

What is an oracle table?

971

Difference between varchar and varchar2 data types?

1158

Explain oracle’s system global area (sga).

1132

What is java oracle used for?

1006

What is a database schema in oracle?

1095