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 does ROLLBACK do ?
How to retrieve the count of updated rows?
Explain oracle data types with examples?
can you write commit in triggers?
what is a view?
Explain an exception and its types?
What is difference between sid and service name in oracle?
What is set verify off in oracle?
how to find full database size
1 Answers BirlaSoft, Consultancy,
What is the difference between a user and a schema in oracle?
How do I use os authentication with weblogic jdriver for oracle and connection pools?
How to Select second Maximum salary in a Table ?