Interested to Buy Any Domain ? << Click Here >> for more details...
write a query that displays every Friday in a year with date?
- 5 Answers
- 6699 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
What types of joins are used in writing subqueries?
Explain the use of indexes option in imp command.
How to list all user accounts in oracle?
Explain the dml?
What is a synonym? What are its various types?
how the Oracle Prepares the Execution Plan and how it chooses the Optimal one?
How to lock and unlock a user account in oracle?
how do u setup a replication site?
What exactly do quotation marks around the table name do?
What is raw datatype?
How to work with data objects interactively?
How to write date and time interval literals in oracle?
What is oracle used for?
What is a nested table and how is it different from a normal table?
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
