Interested to Buy Any Domain ? << Click Here >> for more details...
how to get last monday of a month?
- 2 Answers
- 6494 Views
- Multifonds, I also Faced
- E-Mail Answers
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 |
Do you know about aggregate functions? What is row num function? Can it be used all databases?
1 Answers Bravura Solutions, Cap Gemini,
How to create a table index?
what is partitioning? Types of partitioning. explain? what is the new kind of partitioning type introduced in 9i?
How can we find out the current date and time in oracle?
How to export your connection information to a file?
what is a Nested Loop join?
write sql query following source are EmpID, Salary 101 1000 102 2000 103 3000 I want the output format like following empid,sal,composite_sal 101 1000 1000 102 2000 3000 103 3000 6000
How to delete a column in an existing table?
Explain oracle instance.
You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?
How to omit columns with default values in insert statement in oracle?
How to add another datafile to a tablespace?
Oracle General 
