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;

Differentiate between function and procedure in oracle.

1034

---

What is the usage of analyze command in oracle?

1054

---

Explain an index?

1107

---

Query to retrieve record for a many to many relationship ?

2477

---

How to drop an existing table in oracle?

1030

---

How to do clean up if create database failed?

994

---

Why do you use stored procedures and state some of its disadvantages?

988

---

How does one get the view definition of fixed views/tables?

981

---

How to write date and time interval literals in oracle?

999

---

Differentiate between post-database commit and post-form commit?

995

---

What are the attributes of cursor?

1015

---

when we are importing items in inventory, showing errors, Oracle support suggested us for running scripts & also suggested if we run scripts, iprocurement applicaation if is there it will show shared and if we go in future for iprocurement, it wont work. So kinldy suggest any functional solution.

1959

---

What are a collation and state the different types of collation sensitivity?

1124

---

What is the usage of control file in oracle?

1050

---

How to load a large xml file?

1020

---