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

how to get last monday of a month?

Question Posted / shailesh

2 Answers
6597 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

Why oracle is used?

1108

Explain the types of exception?

1195

What is a user role in oracle?

1186

What is truncate oracle?

1016

What are transaction isolation levels supported by oracle?

1116

How to start your 10g xe server?

1089

How to convert characters to dates in oracle?

1152

What is hot backup and logical backup?

1114

Explain the use of control file?

1178

when we are importing items in inventory, showing errors, Oracle support suggested us for running scripts & also suggested if we run scripts, iprocurement applicaation if is there it will show shared and if we go in future for iprocurement, it wont work. So kinldy suggest any functional solution.

2046

How to increment dates by 1 in oracle?

1138

How to execute a stored program unit?

1128

does the query needs a hint to access a materialized view?

1910

Can we write dml statement in function in oracle?

1125

What is an oracle data file?

1163