What is rowid and rownum in oracle?
List the types of joins used in writing subqueries?
What is difference between truncate and delete?
How to define a data source name (dsn) in odbc manager?
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.
What are temporal data types in oracle?
What are a cluster and non-cluster index?
Differentiate between function and procedure in oracle.
How to drop an index in oracle?
Explain what are the uses of rollback segment?
State the various uses of dbcc command?
In oracle there is column command, how will you explain that?
 How to use an oracle sequence generator in a mapping?
What is oracle latest version?
How to find the duplicate rows count from employees table in oracle?