Im tryin to do a select statement here without having toad prompt
me...

VARIABLE TEST_1 NUMBER;

TEST_1 := 1747502;

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

-Jim

On 14 May 2007, jamesfer@hotmail.com wrote:

Do you mean, you are using sqlplus?

exec :TEST_1 := 1747502;

SELECT * FROM PS_RC_CASE WHERE CASE_ID = :TEST_1;

--
Galen Boyer