How to rollback the current transaction in oracle?

1050

Explain about integrity constraint?

1122

how the Oracle Prepares the Execution Plan and how it chooses the Optimal one?

2344

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.

5327

What is recycle bin in Oracle?

1146

What is the purpose of save points in oracle database?

1110

Explain an exception and its types?

1073

What is a table index in oracle?

1129

How to do a full database export?

1104

What is raw datatype?

1134

How to select an oracle system id (sid)?

1060

1) What is ONE_SIZE_FITS_ALL approach? 2) Explain the Common & Variable Header of DATA FILE? 3) What are the Drawbacks to using OMF DB? and the Advantages? 4) List out the Advantages of Undo T.spaces over the Undo SEGMENT? 5) Difference between the Temporary tablespace with TEMPFILE and the Tablespace with TEMPORARY Keyword? 6) What are the situation extents are freeing for reuse.

2087

How to create a new view in oracle?

1076

How to find out what oracle odbc drivers are installed?

1040

How to write a left outer join with the where clause in oracle?

1082