Answer Posted / mani

Select max(rownum) from table_name;

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.

5293

---

Using the relations and the rules set out in the notes under each relation, write statements to create the two sequence generators specified in the notes.

2066

---

What are the various oracle database objects?

1105

---

Difference between the “verify” and “feedback” command?

1320

---

What is procedure overloading in oracle?

1006

---

Difference between open_form and call_form in oracle.

1107

---

What is MTTR advisor in Oracle?

1049

---

I have a database backup file in .db (ext) form how to conver it into .dmp (ext.) for oracle database

2089

---

What is oracle join syntax?

960

---

What is the difference between Delete, Truncate and Drop in Oracle?

1086

---

What are the different types of synonyms?

1091

---

Is oracle an operator?

892

---

What is a server parameter file in oracle?

1018

---

What is a nvl function? How can it be used?

971

---

How to define an anonymous procedure without variables?

1041

---