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

Explain the use of consistent option in exp command.

1068

---

How would you edit your CRONTAB to schedule the running of /test/test.sh to run every other day at 2PM?

1900

---

what is the dual table in oracle?

993

---

List the types of joins used in writing subqueries?

998

---

How to connect to a local oracle 10g xe server?

992

---

What is recycle bin in Oracle?

1152

---

Why does oracle 9i treat an empty string as null?

1057

---

How to display row numbers with the records?

1080

---

Is there an oracle sql query that aggregates multiple rows into one row?

983

---

How to create a new table in oracle?

1158

---

What happens to the current transaction if the session is ended?

1098

---

How to define a data source name (dsn) in odbc manager?

1034

---

How to create a table interactively?

1093

---

What is a private synonym?

1589

---

How to use subqueries in the from clause in oracle?

1113

---