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'
/

6. Display the client name and order date for all orders using the traditional method.

2266

---

How do I know if oracle client is installed on windows?

978

---

Explain what are the uses of rollback segment?

975

---

IS it possible to built the oracle database without setting the kernal parameters?

2299

---

How to empty your oracle recycle bin?

997

---

How to load excel data sheet to oracle database

991

---

What is a nvl function? How can it be used?

975

---

How do you tell what your machine name is and what is its IP address?

2029

---

How much memory your 10g xe server is using?

1073

---

How to pass a cursor variable to a procedure?

1063

---

Differentiate between post-database commit and post-form commit?

995

---

What are the differences between lov and list item?

1017

---

How to update values in a table in oracle?

977

---

How to grant create session privilege to a user in oracle?

964

---

What is a oracle database?

1014

---