Oracle APPS Consultancy
SSS Oracle APPS Consultancy
Title
(Move to ...)
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
‹
›
Home
View web version
No comments:
Post a Comment