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

How to open a cursor variable?

1048

---

What are the differences between primary key and unique key?

1017

---

How to assign data of the deleted row to variables?

1083

---

What happens if you use a wrong connect identifier?

1076

---

What is different types of joins?

1030

---

How can windows applications connect to oracle servers?

1070

---

Her departmandaki isçilerden empno' su ikinci sirada olan isçilerin empno, deptno, hiredate, sira_no bigilerini döndüren sorguyu yaziniz?

1999

---

How to bring a tablespace offline?

1074

---

normally database take to refresh time 2 hours. but client asked iwant to refresh with in 5 min that same database. do you have any option in BO and Oracle? explain me briefly...kavi

2220

---

Who developed oracle & when?

1015

---

is there a tool to trace queries, like profiler for sql server?

1149

---

How to check your oracle database 10g xe installation?

998

---

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

1146

---

What is meant by a deadlock situation?

1118

---

What is an oracle user role?

992

---