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'

Which dictionary tables and/or views would you look at to diagnose a locking issue?

1905

---

Can we convert a date to char in oracle and if so, what would be the syntax?

1004

---

What do you mean by redo log file mirroring?

1022

---

What is private procedure oracle?

1006

---

What is the difference between PFILE and SPFILE in Oracle?

1054

---

How many types of segments in Oracle?

1062

---

How does the on-delete-cascade statement work?

1098

---

what happened to the global index when I truncate the data in one of the partition?

2014

---

why should i declare foreign key constraint as self relation instead of binary relation in tables ?

2035

---

What is ASM (Automatic Storage Management) in Oracle?

1186

---

what is the difference between substr and instr function in oracle?

1077

---

What is oracle database 10g express edition?

1114

---

How to add a new column to an existing table in oracle?

1131

---

How to handle a single quote in oracle sql?

1035

---

What is the relation of a user account and a schema?

1125

---