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
- 4191 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 |
what is the use of triggers in Java program? I mean where do we use triggers in Java programming?
What is data block in Oracle?
What is TNS File
What is use of oracle?
How would you best determine why your MVIEW couldnt FAST REFRESH?
how may join possible between (requisition with purchase order)
How do I know if oracle is installed on windows?
find out first highest salary?
10 Answers Verinon Technology Solutions,
Table1- have two column filename data AFGDFD-20112011 hi how r u bsdasd-23042011 name shoud be in bold Now i want output like filename data AFGDFD hi how r u bsdasd name shoud be in bold Kindly answer this
What is the difference between substr & instr functions?
What is Database Buffers ?
How many categories of data types in oracle?
Oracle General 
