select order,orderline,decode(shipped date,null,'not shipped',sh

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 / chanti

Answer Posted / chanti

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

Is This Answer Correct ?

1 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What is a package ? What are the advantages of package ?

1138

What is redo log?

1116

How to define a sub function?

1202

What query tells you how much space a tablespace named test is taking up, and how much space is remaining?

2341

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

1053

How to sort output in descending order in oracle?

1104

What is key preserved table?

1083

What is oracle in java?

1018

What is Reduced List of Values?

2245

What happens if recursive calls get out of control?

1140

what are the advantages of running a database in archive log mode?

2258

What is the difference difference between $ORACLE_HOME and $ORACLE_BASE.

1161

What is a user account in oracle?

1173

What are the limitations oracle database 10g xe?

1097

how can we store any pdf file in oracle

2221