stored outlines and bind variables
From: hrishy <hrishys_at_yahoo.co.uk>
Date: Wed, 3 Feb 2010 14:00:16 +0000 (GMT)
Message-ID: <430908.76506.qm_at_web29002.mail.ird.yahoo.com>
Hi
I have two sql statements like this
1)select ename from emp where empno :=b1
2)select ename from emp where empno := b2
if i create a stored outline for the first will oracle use the stored outline for the second ?statement ?
If not can i resort to using profiles can a single profile be used in this case for
regards
Date: Wed, 3 Feb 2010 14:00:16 +0000 (GMT)
Message-ID: <430908.76506.qm_at_web29002.mail.ird.yahoo.com>
Hi
I have two sql statements like this
1)select ename from emp where empno :=b1
2)select ename from emp where empno := b2
if i create a stored outline for the first will oracle use the stored outline for the second ?statement ?
If not can i resort to using profiles can a single profile be used in this case for
regards
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Feb 03 2010 - 08:00:16 CST