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 define and use table alias names in oracle?

989

Is there a combination of "like" and "in" in sql?

1114

What is Segment Advisor in Oracle?

1146

How to get execution statistics reports on query statements?

1153

Explain the truncate in oracle?

1011

What is a dead lock in oracle?

1175

What is oracle database 10g express edition?

1168

What are the differences between blob and clob in oracle?

1135

How to resolve name conflicts between variables and columns?

1078

Can u please explain me the Discussion on Except ,using cast like type cast. Question in the context of difference between two tables

2118

Can we use bind variables in oracle stored procedure?

987

What is the dynamic sql in oracle?

1134

How to download oracle database 10g xe?

1066

What are the logical operations?

1169

What is program global area (pga) in oracle?

1090