Oracle APPS Consultancy
SSS Oracle APPS Consultancy
Title
Home
APPS
PLSQL
PO
OM
Inventory
AR
GL
Form
Forms Personlization
Report
Monday, 28 October 2013
How does trace (and explain) SQL statements from SQL* plus?
Auto trace facility:
Set autotrace on
Select * from emp where empno =’7369’;
DBMS_XPLAN package:
Explain plan for Select * from emp where empno =’7369’;
Select * from table (dbms_xplan.diplay);
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment