16. Display the order number, order line number and the
shipping date. If the shipping date is null, display the
string <not shipped yet>.
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
Is oracle a relational database?
Can we commit inside a function in oracle?
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.
Why do you use stored procedures and state some of its disadvantages?
Please explain compound trigger in oracle?
What to do if dba lost the system password?
How will you write a query to get a 5th rank student from a table student_report?
Is a rollback possible to any savepoint?
How to shutdown your 10g xe server from command line?
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?
Can we write dml statement in function in oracle?
How to delete an existing row from a table in oracle?
How can I create database in oracle?
What is Virtual Private Database in Oracle?
Hi friends can u send the oracle 9i full version download link?????????????? please reply ?