Answer Posted / sureshkumar.somayajula
Explain Plan determines the execution plan for SQL
Statements.
Syntax:
expalin paln
set statement_id= ' Text '
schemaname.Table_name@Databaselink
for Statement.
Is This Answer Correct ? | 6 Yes | 1 No |
Post New Answer View All Answers
What is a full join sql?
What are the different types of constraints?
How to use sql statements in pl/sql?
What is the difference between null value, zero, and blank space?
Why having clause is used in sql?
What are the types of dbms?
What are schema-level triggers?
What is nosql vs sql?
How to avoid using cursors?
explain commit and rollback in mysql : sql dba
Can we use commit inside a trigger?
How do I run a pl sql program?
how to increment dates by 1 in mysql? : Sql dba
Is oracle sql free?
Mention what plvcmt and plvrb does in pl/sql?