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 / chanti
select order,orderline,decode(shipped date,null,'not
shipped',shipped date) from <TN>
| Is This Answer Correct ? | 1 Yes | 1 No |
What are the different pseudo commands? Explain in general?
Does oracle charge for java?
what is kernel?
What is Index and different types of Indexes?
What is difference between Rename and Alias?
How to define a specific record type?
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
what is the exact definition for pointer?
How to end the current transaction in oracle?
How does the on-delete-cascade statement work?
What is the difference between $oracle_base and $oracle_home?
What is a user role in oracle?