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
- 3447 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 |
I have a table that log salary-increase-process have fields: autoid, old_salary, acctno and table EMP: acctno, name, salary I want to list count increase-salary of employees, each have old_salary, new_salary. Help me with SELECT statement, please!
What a SELECT FOR UPDATE cursor represent.?
How would you change old and new values in an insert, delete and update triggers?
Why does Oracle not permit the use of PCTUSED with indexes?
What is clustered table in Oracle?
How to use "in" parameter properly?
How are extents allocated to a segment?
Suppose U install the oracle DB either enterprise edition or express edition in ur personal PC, Is there the Database has been created after ur installation if not then where the oracle's all objects with data be stored?
i wrote a pl/sql procedure. it must run every sunday 4.40 How can i schedule it with the help of dbms_jobs (or another other procedure with out creating bat file,exe file)
How to create lov dynamically at runtime & attach to text field?
What is a View ?
How to create a single index for multiple columns?
Oracle General 
