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

Why packages are used in oracle?

545

---

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

545

---

Is it possible to center an object horizontally in a repeating frame that has a variable horizontal size ?

1882

---

What is a procedure in oracle?

618

---

How to convert csv to table in oracle?

528

---

---

How to use "startup" command to start default instance?

544

---

Difference between the “verify” and “feedback” command?

775

---

Why we use bulk collect in oracle?

538

---

An automatic job running via DBMS_JOB has failedKnowing only that its failed, how do you approach troubleshooting this issue?

1624

---

How to load excel data sheet to oracle database

590

---

Explain the use of record option in exp command.

539

---

What happens if you set the sga too low in oracle?

559

---

What is define in oracle?

571

---

what are the default admin accounts in Oracle 10g ?

512

---

How a tablespace is related to data files?

583

---