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

What is oracle data type?

897

---

How to create a new tablespace in oracle?

932

---

In XIR2 if we lost the administration password .How can we regain the password?thanks in advance.

1869

---

What is a table index?

1009

---

Can we commit inside a function in oracle?

914

---

What is format trigger?

2009

---

We are using Oracle apps with XML publisher.In that,we are facing some problems while giving a Footer in RTF Template.While giving a footer in RTF Template it is Visible in all the pages,but after the PDF is getiing generated,the Footer are Visible on alternate pages only (like on first page ,third page) and so on. Please provide the Solution for getting the Footer on all the pages.

5286

---

Calculate difference between 2 date / times in oracle sql?

985

---

What is the minimum client footprint required to connect c# to an oracle database?

1016

---

What is an oracle database?

983

---

How is it different from a normal table?

965

---

What happens to the current transaction if a ddl statement is executed?

948

---

Why does Oracle not permit the use of PCTUSED with indexes?

2364

---

material view and view disadvantages?

1016

---

How to convert numbers to characters in oracle?

966

---