how to get last monday of a month?

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

Which is better Oracle or MS SQL? Why?

3974


How to define an oracle sub procedure?

597


WHEN CURSOR MOVES FROM ONE FORM TO ANOTHER FORM, HOW MANY TRIGGER WILL BE FIRED AND WHAT ARE THEIR SEQUENCE?

1804


Who developed oracle & when?

571


Is java required for oracle client?

548






What is a sub query? What are its various types?

583


What are the uses of a database trigger?

516


How we can able to import our own template (users designed MS-Word templates) which has many tabular columns; need to pass some values generate by Oracle-reports9i? Actually need to import more than 400 MS-Word templates into Oracle Reports-9i to minimize layout design in Reports.

1612


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

1699


What do you know about normalization? Explain in detail?

499


What is a static data dictionary in oracle?

569


Why cursor variables are easier to use than cursors?

570


What is a data lock in oracle?

611


What is parameterized cursor in oracle?

578


Will you be able to store pictures in the database?explain.

538