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

Is there a function to split a string in plsql?

1008

How to resolve name conflicts between variables and columns?

995

How to delete a column in an existing table?

1039

Describe the types of sub query?

954

What is oracle sid?

903

What are temporal data types in oracle?

1084

What is the usage of control file in oracle?

1046

Explain what are the characteristics of data files?

1045

Can u please explain me the Discussion on Except ,using cast like type cast. Question in the context of difference between two tables

2017

How to define a specific record type?

1048

What is oracle thin client?

985

What is a nested table and how is it different from a normal table?

1004

What are the attributes that are found in a cursor?

1028

What do you mean by merge in oracle?

955

How to upsert (update or insert into a table)?

970