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 to pass a parameter to a cursor in oracle?

0 Answers  


How to do clean up if create database failed?

0 Answers  


How to delete a user account in oracle?

0 Answers  


Can the default values be assigned to actual parameters?

1 Answers  


State the difference between a primary key and foreign key?

0 Answers  






For a field in a repeating frame, can the source come from the column which does not exist in the data group which forms the base for the frame ?

0 Answers   Oracle,


How would you begin to troubleshoot an ORA-3113 error?

0 Answers  


Explain view?

0 Answers  


how many outer joins are used in a single sql query? is there any limitations for using of outer joins?

2 Answers   BOB Technologies, Cap Gemini, IBM,


1.display list of all users from ur data base.what is the query?

3 Answers   CGI, IBM,


hai, I am searching job on Oracle10g and PL/sql,Unix... can any one send me resume format. an suggest me how to prepare.. ann books..

1 Answers  


How to insert multiple rows with one insert statement in oracle?

0 Answers  


Categories
  • Oracle General Interview Questions Oracle General (1808)
  • 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)