Re: Explain Plan with BIND Variables

What is the error ?
I think with 7.3.3 you should be able to do

variable my_value number

explain plan .......

As well as Sybrand's comment about
bind variables and the histogram effect, you may also get side-effects due to
implicit type conversion. Bind variables have a type, literals are a little more fluid.

--

Jonathan Lewis
Yet another Oracle-related web site:  http://www.jlcomp.demon.co.uk

Stephan Schaefer wrote in message <38D8B0E0.4B0EBDC0_at_camline.com>...


>Two questions about bind variables and execution plans

>

>Question 1

>=================================================================

>How can I see the execution plan for the following statement:

>

>select * from my_table where column1 = :my_value ;

>

>Within SQL*Plus I cannot enter

>explain plan set statement_id = 'my_id' for

>  select * from my_table where column1 = :my_value ;

>