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

how to get last monday of a month?

Question Posted / shailesh

2 Answers
6471 Views
Multifonds, I also Faced
E-Mail Answers

Answer Posted / shailesh

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

Is This Answer Correct ?

6 Yes

4 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How to write a query with an inner join in oracle?

1042

What is a trigger oracle?

1092

Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?

1990

What is flashback in Oracle?

1022

What is materialized view in Oracle?

1074

How to select some rows from a table in oracle?

1078

What is a oracle database?

1059

Please send me Informatica 8.1 certification dumps, my mail id mona85gupta@gmail.com

1865

What is a server parameter file in oracle?

1059

Why do I get unexpected characters from 8-bit character sets in weblogic jdriver for oracle?

1087

What is a relational database management system?

1121

State the difference along with examples between Oracle 9i, Oracle 10g and Oracle 11i.

1034

What is parameterized cursor in oracle?

1154

What is a read write transaction in oracle?

1093

How many types of tables supported by oracle?

1079