write a query that displays every Friday in a year with date?
Answer Posted / 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 |
Post New Answer View All Answers
How to call a stored function in oracle?
Explain what are the different type of segments?
What is the quickest way to fetch the data from a table?
What are the varoius components of physical database structure of oracle database?
21. Using a set operator, display the client number of all clients who have ever placed an order and whose whose name does not contain the string Sm.
how may join possible between (requisition with purchase order)
Can a parameter be passed to a cursor?
How do I connect to oracle database?
What is translate in oracle?
If any one has information regarding interview of NIC (National Informatics Centre),it would be of great help...
What is the difference between $oracle_base and $oracle_home?
Where are the settings stored for each instance in oracle?
How to connect the oracle server as sysdba?
if you ctreate table identity
1) What is ONE_SIZE_FITS_ALL approach? 2) Explain the Common & Variable Header of DATA FILE? 3) What are the Drawbacks to using OMF DB? and the Advantages? 4) List out the Advantages of Undo T.spaces over the Undo SEGMENT? 5) Difference between the Temporary tablespace with TEMPFILE and the Tablespace with TEMPORARY Keyword? 6) What are the situation extents are freeing for reuse.