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 is the recommended interval at which to run statspack snapshots, and why?

2923

Difference between open_form and call_form in oracle.

1166

How to define a sub function?

1138

What is user managed backup in Oracle?

1148

What is a connect identifier?

1045

What are the attributes of the cursor?

1004

Difference between varchar and varchar2 data types?

1189

what is the difference between data migration and production migration.

2350

Explain an index?

1140

Explain the use of tables option in exp command.

1119

How to install oracle odbc drivers?

1094

What is the difference between primary key and unique key and foreign key in oracle?

983

I have a database backup file in .db (ext) form how to conver it into .dmp (ext.) for oracle database

2143

please explain.. DB architecture ...

2029

What is a directory object?

1101