Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 3985 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 |
Can select statements be used on views in oracle?
how to do daily transactions with out sql* loader control file regesterd in apps?
Explain the importance of .pll extension in oracle?
What is a database table in oracle?
Explain the statement?? ALTER TABLE TABLE_NAME MOVE; What it the use of above statement??
What is the difference between an Oracle Schema and an Oracle Instance?
How do we switch from init.ora file to asp file?
What are the system predefined user roles?
How to export data with a field delimiter?
What is the difference between "as" and "is" in an oracle stored procedure?
How to update rows in table, suppose i have lacks of rows in table how to update total table with update statement. Can u please any one answer this question with update statement.
which statement is running fastly ie insert or delete?
Oracle General 
