Answer Posted / colarif

select daten, to_char(daten,'DY') dayn from
( select to_date('31-dec-15') + level daten from dual
connect by level <= 366)
where to_char(daten,'DY') = 'FRI'
and to_char(daten,'YYYY') = 2016;

Is the After report trigger fired if the report execution fails ?

2907

---

IS it possible to built the oracle database without setting the kernal parameters?

2339

---

Hi friends can u send the oracle 9i full version download link?????????????? please reply ?

1861

---

How to get execution path reports on query statements?

976

---

What are operators in oracle?

1051

---

How to use subqueries with the in operator using oracle?

1088

---

How to export your own schema?

1007

---

How do I connect to oracle?

1027

---

Differentiate between function and procedure in oracle.

1069

---

How to assign query results to variables?

1044

---

How to convert numbers to characters in oracle?

1026

---

How to create a stored function in oracle?

1100

---

In oracle there is column command, how will you explain that?

1040

---

How to retrieve the count of updated rows?

1120

---

Explain the difference between a procedure and a function? What do you understand by those terms?

1071

---