how to get last monday of a month?

Question Posted / posamram

Answers were Sorted based on User's Feedback

how to get last monday of a month?..

Answer / posamram

select next_day(last_day(sysdate),'MON')-7 FROM DUAL;

Is This Answer Correct ?

13 Yes

2 No

how to get last monday of a month?..

Answer / shailesh

select NEXT_DAY(last_day(sysdate)-7,'THURSDAY') from dual;

Is This Answer Correct ?

6 Yes

4 No

More Oracle General Interview Questions

2. Display the item number and total cost for each order line (total cost = no of items X item cost). Name the calculated column TOTAL COST.

What is STATSPACK tool?

How you open and close a cursor variable.Why it is required?

I want a table like, no name address addr1 addr2 So i want columns like addr1,addr2 under address column. Can one please answer me. Advance Thanks.

How to update values in a table in oracle?

What is meant by joins?

Does facebook use oracle?

what are corelated subqueries

How to Select second Maximum salary in a Table ?

What is meant by recursive hints ?

Can we protect our pl/sql source code?

What is coalesce function?

For more Oracle General Interview Questions Click Here