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

how to get last monday of a month?

Question Posted / shailesh

Answer Posted / shailesh

Is This Answer Correct ?

6 Yes

4 No

Please Help Members By Posting Answers For Below Questions

How to drop an index?

910

How to get the Installed Oracle Version Information ?

1074

Explain about integrity constraint?

1078

what is partitioning? Types of partitioning. explain? what is the new kind of partitioning type introduced in 9i?

2220

Explain what are clusters?

1041

What happens to the current transaction if the session is killed?

927

How to create a temporary table in oracle?

1194

What is integrity and what is constraint??Explain with example

2215

Use of an integrity constraint is better to validate data. Explain

978

How to unlock the sample user account in oracle?

918

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

977

Why oracle is used?

998

How to declare a local variable?

1054

Can select statements be used on views in oracle?

985

What are the common oracle dba tasks?

1072