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
What is a package ? What are the advantages of package ?
What is redo log?
How to define a sub function?
What query tells you how much space a tablespace named test is taking up, and how much space is remaining?
What is the simplest tool to run commands on oracle servers?
How to sort output in descending order in oracle?
What is key preserved table?
What is oracle in java?
What is Reduced List of Values?
What happens if recursive calls get out of control?
what are the advantages of running a database in archive log mode?
What is the difference difference between $ORACLE_HOME and $ORACLE_BASE.
What is a user account in oracle?
What are the limitations oracle database 10g xe?
how can we store any pdf file in oracle