Interested to Buy Any Domain ? << Click Here >> for more details...
write a query that displays every Friday in a year with date?
- 5 Answers
- 6264 Views
- Flipkart, HCL, TCS, I also Faced
- E-Mail Answers
Answer Posted / anish
select distinct next_day((sysdate-level),'FRI') as fir from dual
connect by level <=(sysdate-to_date('01-Jan-2017','dd-mon-yyyy'))
order by 1 asc
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
What is the sql query to concatenate column values from multiple rows in oracle?
How to convert characters to numbers in oracle?
Explain the use of analyse option in exp command.
What are the uses of linked server and explain it in detail?
Where do you use decode and case statements?
What is BBED in Oracle?
I just want to maintain data like an employee can belongs to 3 or more departments . We can resolve this by using composite key but it avoids normalization rules. So Can anyone tell me how can I maintain data.
What is ceil and floor in oracle?
How i can handle exception in large code like 1000 line without distrubing the code or without exception handler sction?
Explain about the analyze command in oracle?
How to drop a stored function?
What is the difference between primary key and unique key and foreign key in oracle?
Can multiple cursors being opened at the same time?
How to write a query with an inner join in oracle?
Which is better Oracle or MS SQL? Why?
