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 |
HI Friends Myself Manoj,i am from bengaluru.i have 1 yr of exp in PLSQL but not upto the mark..now attending interviews but m not able to clear even 1 round..i have attended 3 interviews till today.purpose of writing this query is,i want to know the intreview topics that interviewer going to ask frequently,mainly SCENARIO based questions.IF anybody have any PLSQL projects please give it to me,it will helps me alot.Thanks for your patience.
What is the best way to do multi-row insert in oracle?
Can we write dml statement in function in oracle?
What is a deadlock ? Explain .
Write a trigger example in oracle?
How does Oracle guarantee data integrity of data changes?
Are truncate and delete commands same? If so why?
where we have to use ON clause and where we have to use USING clause in JOINS
what is index?
What is an oracle and why it is used?
How to create a stored procedure in oracle?
in account table account type amount ac1 credit 300 ac2 debit 5000 ac3 credit 3000 ac1 debit 4000 ac3 debit 2000 ac2 credit 4000 write a query how to get sum of credit & sum of debit