EXPLAIN PLAN for multiple SQL statements
EXPLAIN PLAN is often used to generate execution plan of SQL statement or set of SQL statements. But we would always prefer to run EXPLAIN PLAN for each SQL statement and generate its execution plan using DBMS_XPLAN package and then pick up next SQL statement. But we can also run EXPLAIN PLAN for multiple SQL […]