Re: O9i: bind variable questions (special)

sybrandb schrieb am 03.04.2007 in
<1175594979.118378.244430_at_n76g2000hsh.googlegroups.com>:

First: You are a great help!

> 1 in Sql*plus you would do that by declaring a variable
> variable p_deptno number;
> exec :p_deptno := 10
> select * from emp where deptno = :p_deptno
I got it if there is only 1 bind variable, 2 BW I have to try a little. Thanks.

> hardly use sql*worksheet, but assume it works in sql worksheet too.
> exec is short hand for
> begin <code> end;

> 2 Search on asktom.oracle.com for 'dynamic in list'
This is what I wanted to know. Many thanks. Well explained.

> Hth

Yes, it did (like your answers before)
> --
> Sybrand Bakker
> Senior Oracle DBA

Andreas Mosmann

-- 
wenn email, dann AndreasMosmann <bei> web <punkt> de