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 |
How to resolve name conflicts between variables and columns?
How to drop a stored procedure in oracle?
1.display list of all users from ur data base.what is the query?
What is the exact use of Collections?
What is the recommended interval at which to run statspack snapshots, and why?
In Oracle Applications We are Using Sub Ledger Accounting. When we Transfer the Data all modules (AP,AR,CE,FA) to SLA We done Some customizations? What are They??
How to revoke create session privilege from a user in oracle?
What happens if the update subquery returns multiple rows?
5. Display full details for the creditor/s who has received the single largest payment. Do not use a table join or set operator anywhere in your query.
Give SQL Query to find the number words in a sentence ? ex: 'ram charan singh' then ans:3 Answer:select length(trim('ram charan singh')) - length (replace (trim ( 'ram charan singh'),' ','')) +1 from dual The above query working properly when space between the words is only one &similar But ,If the space between the words is nonuniform. Ex:'ram charan singh is good' ans:5 i am not getting this answer using above query.
What is SYSTEM tablespace and When is it Created?
What is Library Cache in Oracle?