Thursday, January 11, 2007

How to create outlines for sql statements with bind variables and/or key word "into"

alter session set create_stored_outlines=true;
variable x number;
select count(*) into :x from test;
alter session set create_stored_outlines=false;
select sql_text from outln.ol$;
-------------------------------------------------
Now you can see the result,
with both bind variable ":x" and key word "into".

No comments: