16. Display the order number, order line number and the shipping date. If the s

16. Display the order number, order line number and the
shipping date. If the shipping date is null, display the
string <not shipped yet>.

Question Posted / deepakgunji

16. Display the order number, order line number and the shipping date. If the shipping date is null..

Answer / chanti

select order,orderline,decode(shipped date,null,'not
shipped',shipped date) from <TN>

Is This Answer Correct ?

1 Yes

1 No

More Oracle General Interview Questions

Explain about your project and its relation to the current job position you are applying to?

What is a named program unit?

What are the different windows events activated at runtime ?

How to create index-by table in oracle?

How to find the date and time of last updated table?

What are the database administrators utilities available?

How to check your oracle database 10g xe installation?

How to delete a column in an existing table in oracle?

How do I uninstall oracle 11g?

how can db_files > maxdatafiles since db_files is for instance and the later is for database

What are the values that can be specified for OPTIMIZER MODE Parameter ?

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

For more Oracle General Interview Questions Click Here