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?
No Answer is Posted For this Question
Be the First to Post Answer
Explain the difference between a procedure and a function? What do you understand by those terms?
What is the difference between count (*), count (expression), count (distinct expression)?
Describe varray?
How to set up autotrace for a user account?
Difference between an implicit & an explicit cursor.?
hey friends, What are the steps I can do to transfer the database from Microsoft Access 2003 to oracle10g (or SQL) Best regards
What are the type of Synonyms?
What happens to the current transaction if a ddl statement is executed?
how to make an oracle object
t1 col1 col2 nishi 5000 lucky 6700 akash 7000 i want that a query that when i insert 7000 it will show me data already present and data will not insert. if data is not present it will insert.
How to return top 5 rows in oracle?
Difference between varchar and varchar2 data types?