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 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 to define an explicit cursor in oracle?
What is an anonymous block?
How to drop an index in oracle?
Explain an exception and its types?
how to clone 9i Database on to 10g Database.
Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.
while i take backup using ibm tsm the following errors occurred: rman-03009 ora-19513 ora-27206 ora-19502 ora-27030 ora-ora19511
Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracles. What database recovery options are available? Database is in archive log mode.
how to join query for one source type is oracle another source type is sql server ?
how to convert .db (extention) database file into .dmp (extention ) for oracle database ?
what's query optimization and without use of IN AND Exist can we get another way data from query
How do you tell what your machine name is and what is its IP address?
How would you go about verifying the network name that the local_listener is currently using?
State any two functions of oracle?
How does Oracle guarantee data integrity of data changes?