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'

How to sort the query output in oracle?

1033

---

What are the differences between date and timestamp in oracle?

1058

---

State any two functions of oracle?

1051

---

Can select statements be used on views in oracle?

1038

---

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

1015

---

What is the Tune Query

2302

---

Can we protect our pl/sql source code?

1052

---

Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.

1958

---

what are the advantages of running a database in archive log mode?

2209

---

How to create id with auto_increment on oracle?

997

---

How do we get field detail of a table?

1089

---

How to update values on multiple rows in oracle?

1044

---

How to define an anonymous procedure without variables?

1115

---

What is the difference between count (*), count (expression), count (distinct expression)?

1014

---

How to recover a dropped table in oracle?

1055

---