Interested to Buy Any Domain ? << Click Here >> for more details...
write a query that displays every Friday in a year with date?
- 5 Answers
- 6544 Views
- Flipkart, HCL, TCS, I also Faced
- E-Mail Answers
Answer Posted / colarif
select daten, to_char(daten,'DY') dayn from
( select to_date('31-dec-15') + level daten from dual
connect by level <= 366)
where to_char(daten,'DY') = 'FRI'
and to_char(daten,'YYYY') = 2016;
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Which is better Oracle or MS SQL? Why?
What happens to the data files if a tablespace is dropped?
How to open a cursor variable?
How many categories of data types in oracle?
What is execute immediate in oracle?
What is bind variable in oracle 11g?
Explain the dml?
What is Reduced List of Values?
Explain what are clusters?
What is sequence?
In XIR2 if we lost the administration password .How can we regain the password?thanks in advance.
How to convert characters to numbers in oracle?
How to load a large xml file?
What is a package in oracle?
Explain cascading triggers.
