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
- 3968 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / chanti
select order,orderline,decode(shipped date,null,'not
shipped',shipped date) from <TN>
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
How do you find current date and time in oracle?
Explain what are the characteristics of data files?
What is the difference between sharding and partitioning?
what is the scripts in data base?
How to display row numbers with the records?
i have a question here... As of my knowledge, when we apply an index (b-tree)on a column, internally it arranges the data in b-tree format and do the fetching process correspondingly... and my quetion is... How a bit-map index arranges the data internally when applied on a column?IS it in b-tree format or whatelse?
How remove data files before opening a database?
What is analyze command used for?
How to pass parameters to procedures?
I have a parent program and a child program. I want to write a statement in Exception Block of the parent program so that when the statement in the exception block is executed, the control goes to the next statement in the parent block bypassing the child block.How do i do that?
How do you increase the OS limitation for open files (LINUX and/or Solaris)?
What is a static data dictionary in oracle?
How many types of database triggers exist?
How do I spool in oracle?
What is materialized view in Oracle?
