Interested to Buy Any Domain ? << Click Here >> for more details...
write a query that displays every Friday in a year with date?
- 5 Answers
- 6696 Views
- Flipkart, HCL, TCS, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
How many objectname will be created for a single table drop function? Why 'flashback' query giving error "ORA-38312: original name is used by an existing object" while getting the table?
Explain the use of indexes option in exp command.
How a tablespace is related to data files?
What is the scope of a local variable?
We are using Oracle apps with XML publisher.In that,we are facing some problems while giving a Footer in RTF Template.While giving a footer in RTF Template it is Visible in all the pages,but after the PDF is getiing generated,the Footer are Visible on alternate pages only (like on first page ,third page) and so on. Please provide the Solution for getting the Footer on all the pages.
Explain what are the type of synonyms?
Can a formula column referred to columns in higher group ?
Why oracle is used?
What suggestions do you have to reduce the network traffic?
How to create a temporary table in oracle?
What is meant by raw datatype?
Is a rollback possible to any savepoint?
How to use values from other tables in update statements using oracle?
How to save query output to a local file?
What is ordinary table in oracle?
