Interested to Buy Any Domain ? << Click Here >> for more details...
write a query that displays every Friday in a year with date?
- 5 Answers
- 6535 Views
- Flipkart, HCL, TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / ranjan
SELECT C_DATE, TO_CHAR(C_DATE,'DY')
FROM
(
SELECT TO_DATE('01-JAN-2016','DD-MON-YYYY')+LEVEL-1 C_DATE
FROM DUAL
CONNECT BY LEVEL <= (SYSDATE - TO_DATE('01-JAN-2016','DD-MON-YYYY')+1)
)
WHERE TO_CHAR(C_DATE,'DY') = 'FRI'
| Is This Answer Correct ? | 11 Yes | 0 No |
Answer / basanti meher
SELECT A_DATE, TO_CHAR(A_DATE,'DY')
FROM
(
SELECT TO_DATE('01-JAN-2016','DD-MON-YYYY')+LEVEL-1 A_DATE
FROM DUAL
CONNECT BY LEVEL <= (366)
)
WHERE TO_CHAR(A_DATE,'DY') = 'FRI'
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / sivareddy
SELECT C_DATE, TO_CHAR(C_DATE,'DY')
FROM
(
SELECT TO_DATE('01-JAN-2016','DD-MON-YYYY')+LEVEL-1 C_DATE
FROM DUAL
CONNECT BY LEVEL <= to_date('31-dec-2016','dd-mon-yyyy') - TO_DATE('01-JAN-2016','DD-MON-YYYY')+1)
WHERE TO_CHAR(C_DATE,'DY') = 'FRI'
/
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / 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 |
Is truncate autocommit in oracle?
How can we view last record added to a table?
What is an oracle and why it is used?
What are the uses of linked server and explain it in detail?
How to write an inner join with the where clause in oracle?
What are joins..how many types of joins are there?
29 Answers Amdocs, CSC, TCS,
primary key is foreign key for the same table?
What are the uses of synonyms?
What is the difference between a hot backup and a cold backup in oracle?
how to retrieve daily sal from emp table in oracle 10g
What is the quickest way to fetch the data from a table?
1.display list of all users from ur data base.what is the query?
Oracle General 
