16. Display the order number, order line number and the
shipping date. If the shipping date is null, display the
string <not shipped yet>.
- 1 Answers
- 3556 Views
- Wipro, I also Faced
- E-Mail Answers
Answer / chanti
select order,orderline,decode(shipped date,null,'not
shipped',shipped date) from <TN>
| Is This Answer Correct ? | 1 Yes | 1 No |
Difference between hot backup vs. Cold backup?
how many types of index?
sql query to get zero records from a table
In Oracle Clinical 4.5.0, can the VIEW_TEMPLATE_ID column in DATA_EXTRACT_VIEWS table contain NULL value?
Please explain drop constraint oracle?
Is java required for oracle client?
What is define in oracle?
how to produce numbers from 1 to 10 using dual table
how to convert .db (extention) database file into .dmp (extention ) for oracle database ?
Which is better Oracle or MS SQL? Why?
Explain the use of constraints option in exp command.
What is oracle thin client?
Oracle General 
