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
How do we accept inputs from user during runtime?
What is a relationship and what are they?
What are the two characteristics of a primary key?
What is rank () in sql?
define join and explain different type of joins? : Sql dba
Can ddl statements be used in pl/sql?
What is a boolean in sql?
Is sql a dbms?
Differentiate between pl/sql and sql?
What operators deal with null?
Can we use the cursor's to create the collection in PL/SQL?
what are wild cards used in database for pattern matching ? : Sql dba
What are types of indexes in sql?
What is group function in sql?
What do you mean by rowid?