1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82
|
mohamed@mhouri> select * from emp;
14 rows selected.
mohamed@mhouri> select * from table(dbms_xplan.display_cursor);
PLAN_TABLE_OUTPUT
---------------------------------------------------------------------------
SQL_ID a2dk8bdn0ujx7, child number 0
-------------------------------------
select * from emp
Plan hash value: 3956160932
--------------------------------------------------------------------------
| Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time |
--------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | | | 3 (100)| |
| 1 | TABLE ACCESS FULL| EMP | 14 | 532 | 3 (0)| 00:00:01 |
--------------------------------------------------------------------------
13 rows selected.
mohamed@mhouri> declare
2 c clob;
3 begin
4 SELECT sql_fulltext INTO c FROM v$sqlarea WHERE sql_id = 'a2dk8bdn0ujx7';
5 execute immediate c;
6 end;
7 /
PL/SQL procedure successfully completed.
mohamed@mhouri> var n number;
mohamed@mhouri> exec :n := 42
PL/SQL procedure successfully completed.
mohamed@mhouri> select * from emp where lnnvl(:n = 0);
14 rows selected.
mohamed@mhouri> select * from table (dbms_xplan.display_cursor);
PLAN_TABLE_OUTPUT
-------------------------------------------------------------------------------------
SQL_ID 8t2pwab82pbqu, child number 0
-------------------------------------
select * from emp where lnnvl(:n = 0)
Plan hash value: 3896240783
---------------------------------------------------------------------------
| Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time |
---------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | | | 3 (100)| |
|* 1 | FILTER | | | | | |
| 2 | TABLE ACCESS FULL| EMP | 14 | 532 | 3 (0)| 00:00:01 |
---------------------------------------------------------------------------
Predicate Information (identified by operation id):
---------------------------------------------------
1 - filter(LNNVL(:N=0))
19 rows selected.
mohamed@mhouri> declare
2 c clob;
3 begin
4 SELECT sql_fulltext INTO c FROM v$sqlarea WHERE sql_id = '8t2pwab82pbqu';
5 execute immediate c;
6 end;
7 /
declare
*
ERROR at line 1:
ORA-01008: not all variables bound
ORA-06512: at line 5 |