how to get last monday of a month?
Answers were Sorted based on User's Feedback
Answer / posamram
select next_day(last_day(sysdate),'MON')-7 FROM DUAL;
| Is This Answer Correct ? | 13 Yes | 2 No |
Answer / shailesh
select NEXT_DAY(last_day(sysdate)-7,'THURSDAY') from dual;
| Is This Answer Correct ? | 6 Yes | 4 No |
Is oracle a relational database?
Compare and contrast between sql and sql server and explain its various functions?
What are the arithmetic operations?
How would you optimize a slow SQL query?
How to use "in out" parameter properly?
What do you mean by a deadlock?
What are the predefined tablespaces in a database?
What is Java Pool in Oracle?
What is oracle rowcount?
hi friends, I have a table A col as status|NUM and value as open |1 open |2 close |3 close |3 the O/P should be open|close 1 |3 2 |4
Without giving condition how to retrieve the unmatched records from table.
Explain alias?