Answer Posted / mkjmkumar
CBO Evaluates the cost of available execution paths and
selects the execution path that has lowest relative cost.
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
Explain alias?
I have some query regarding Report generation from Oracle Apps "PO module". I have to generate a report where table columns are as below: Vendor_name Invoice No PO Number Item_Quantity Value of Goods Date of Shipping Name_of_the_transport Date_of_receipt_issued. Now my questions is :from which table/column I can get the information of "Name_of_the_transport" column. Thanks in advance.
What exactly do quotation marks around the table name do?
What privilege is needed for a user to create indexes in oracle?
src name sex a,male b,female c,male d,female Required output : male female a,b c,d tried pivot but was not successfull select * from src pivot (max(name) for sex in ('MALE','FEMALE'));
How to create a server parameter file?
What is the effect of setting the value "all_rows" for optimizer_goal parameter of the alter session command? What are the factors that affect optimizer in choosing an optimization approach?
What are the different types of record groups in oracle? Explain each of them
types of indexes and the rationale behind choosing a particular index for a situation.
6. Display the client name and order date for all orders using the traditional method.
hey friends, What are the steps I can do to transfer the database from Microsoft Access 2003 to oracle10g (or SQL) Best regards
What is data file?
What is the difference between pre-select and pre-query?
What is the difference between hot backup and cold backup in oracle?
How to use subqueries with the in operator using oracle?