Display the order number and the number of months since the
order was shipped for all orders that have been shipped in
the last year (365 days). (Hint: Unshipped orders will have
a null value).
Answer / ankit
Select Order_num, MONTHS_BETWEEN(SYSDATE,Shipped_date) no_of_months from Table where shipped_date is not null and to_date('sysdate','YYYY') = '2012';
Is This Answer Correct ? | 0 Yes | 0 No |
Why oracle is used?
17. Display the order number and average item cost for each order.
what is mean by prmary key and foreign key and how can we diffrentiate that? Please answer me. Advance thanks.
What is the difference between column level constraints and table level constraints?
14 Answers IBM, TCS,
Hi can anyone tell me where are the dumps found of OCA certification.. Also the materials to be studied for the preparation.
What is an oracle?
What is an oracle user account?
what are the default admin accounts in Oracle 10g ?
What is where clause in oracle?
What is a view and how is it different from a table?
WHAT IS THE DEFINITION OF DEFAULT CUSTOMER IN AR?
What is a public synonym?