Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> Oracle >> Oracle General
  2. Suggest New Category

write a query that displays every Friday in a year with date?

Question Posted / basanti meher

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to get last row id?

1007

How to view existing locks on the database?

1058

How to start your 10g xe server?

1049

What is parameterized cursor in oracle?

1159

Does oracle charge for java?

1062

ABOUT IDENTITY?

2064

how may join possible between (requisition with purchase order)

2259

What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?

2083

How to test null values?

1114

How to drop a tablespace?

1055

Explain constraining triggers.

1104

Where are the settings stored for each instance in oracle?

1111

what are steps for interface? where is exchange rate defined in which table?

2167

How to best split csv strings in oracle 9i?

1050

What is oracle server autotrace in oracle?

1171