Re: Bind Variable Question

On 14 May 2007, jamesferris_at_hotmail.com wrote:
> Im tryin to do a select statement here without having toad prompt
> me...

Do you mean, you are using sqlplus?

> VARIABLE TEST_1 NUMBER;
>
> TEST_1 := 1747502;
exec :TEST_1 := 1747502;

> SELECT * FROM PS_RC_CASE WHERE CASE_ID = TEST_1;
SELECT * FROM PS_RC_CASE WHERE CASE_ID = :TEST_1;
> How can I get a result set using the above logic without a prompt in
> TOAD...thanks

-- 
Galen Boyer