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

I'm doing my final year and i ve planned to do an oracle certification , is this the rit tim nd wat's the future scope??

How to define a variable to match a table column data type?

Does oracle database need java?

How are extents allocated to a segment?

How to use existing values in update statements using oracle?

What is the oracle implicit cursor?

how to join query for one source type is oracle another source type is sql server ?

What is the difference between primary key and unique key and foreign key in oracle?

Please help me how to write a Query to change the primary key constraint from 1 attribute to another attribute in a table

What do you mean by group by clause?

What is the maximum number of CHECK constraints that can be defined on a column ?

what is null value?

For more Oracle General Interview Questions Click Here