Display the number value in Words?



Display the number value in Words?..

Answer / nishi

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

Is This Answer Correct ?    2 Yes 0 No

Post New Answer

More Oracle General Interview Questions

How can you Enforce Referential Integrity in snapshots ?

1 Answers  


How do I uninstall oracle 11g?

0 Answers  


what is the difference between dbms and rdbms?

3 Answers   Oracle,


How to export your connection information to a file?

0 Answers  


How to create a temporary table in oracle?

0 Answers  






What is Undo Management Advisor in Oracle?

0 Answers   MCN Solutions,


What is memory advisor in Oracle?

0 Answers   MCN Solutions,


How to write date and time interval literals in oracle?

0 Answers  


How to get a list of all user accounts in the database?

0 Answers  


How to turn on or off recycle bin for the instance?

0 Answers  


If I have a select statment which retrives 2 rows, & that rows have the same data in all the fields except the last field and I want to merge the 2 rows to be in 1 row with concatenating the last field which have the different data.... eg: the 1st row has these fields: A-B-C the second row has: A-B-X ........ i want to merge the two row to be in one row like ----> A- B- C,X

2 Answers  


what is null value?

9 Answers  


Categories
  • Oracle General Interview Questions Oracle General (1789)
  • Oracle DBA (Database Administration) Interview Questions Oracle DBA (Database Administration) (261)
  • Oracle Call Interface (OCI) Interview Questions Oracle Call Interface (OCI) (10)
  • Oracle Architecture Interview Questions Oracle Architecture (90)
  • Oracle Security Interview Questions Oracle Security (38)
  • Oracle Forms Reports Interview Questions Oracle Forms Reports (510)
  • Oracle Data Integrator (ODI) Interview Questions Oracle Data Integrator (ODI) (120)
  • Oracle ETL Interview Questions Oracle ETL (15)
  • Oracle RAC Interview Questions Oracle RAC (93)
  • Oracle D2K Interview Questions Oracle D2K (72)
  • Oracle AllOther Interview Questions Oracle AllOther (241)