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

How many different types of indexes we have in oracle?

Which of the following is not a database object TABLESPACE TABLE INDEX NONE

How many memory layers are in the shared pool?

pls explain connect by prior with example and its real time use

what is the syntax of DROP command?

4. Using a set operator, display the creditor number of all creditors who have ever been paid.

Why do I get java.lang.abstractmethoderror when trying to load a blob in the db?

how many types of index?

What is the simplest tool to run commands on oracle servers?

How to select the name of employee who is getting maximum sal with out using subquery

Explain coalesce function?

What is an oracle recycle bin?

For more Oracle General Interview Questions Click Here