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 |
Are truncate and delete commands same? If so why?
How to create an oracle testing table?
Query to get max and second max in oracle in one query ?
34 Answers CTS, Keane India Ltd, TCS, Wipro,
What are the different editions of oracle?
How to create an oracle database manually?
How to create a new user account in oracle?
How to connect to a remote server?
How view is different from a table?
What is the difference between Outer join and Full outer join?
How does oracle handle read consistency?
What is procedure overloading in oracle?
Table E: Name dept month sal 1 A JAN 800 2 B APR 1000 3 A JAN 300 4 A JAN 600 5 C JUN 400 1) SELECT HIGHEST SAL PAID DEPT IN JAN MONTH? 2) WRITE QUERY GET MAX SAL DEPT NO?