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

1 Answers
4071 Views
Wipro, I also Faced
E-Mail Answers

Answer Posted / chanti

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

Is This Answer Correct ?

1 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Is oracle a relational database?

919

Can we commit inside a function in oracle?

967

Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.

2128

Why do you use stored procedures and state some of its disadvantages?

1028

Please explain compound trigger in oracle?

1062

What to do if dba lost the system password?

1172

How will you write a query to get a 5th rank student from a table student_report?

1866

Is a rollback possible to any savepoint?

1098

How to shutdown your 10g xe server from command line?

1088

Can any one explain me when i execute below query.. select months_between('07-JUL-12','10-FEB-12') from dual; Out put:- 4.90322581 How oracle calculate?

1384

Can we write dml statement in function in oracle?

1086

How to delete an existing row from a table in oracle?

1072

How can I create database in oracle?

1028

What is Virtual Private Database in Oracle?

1091

Hi friends can u send the oracle 9i full version download link?????????????? please reply ?

1865