What is the function of Optimizer ?
Answer / guest
The goal of the optimizer is to choose the most efficient
way to execute a SQL statement.
| Is This Answer Correct ? | 4 Yes | 0 No |
What is a Synonym ?
What is a view and how is it different from a table?
What are the composite date types in oracle?
what is analyze command ? what kind of statistics does it generate?
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 does `(+)` do in a where clause?
Explain what are synonyms used for?
write a query to count number of alphabets in given string for example "APPLE" write a query to generate sequence from 50 to 100 write a query to display in single string "ABCD,EFGH,IJKL,PQRS"
What is a Database instance ? Explain?
What is the difference between a primary key & a unique key?
How can we view last record added to a table?
who is the father of oracle and send chodd rules