simple PL/SQL question
From: vk02720 <vk02720_at_my-deja.com>
Date: 27 Jul 2002 15:52:44 -0700
Message-ID: <4d814faa.0207271452.5f9064da_at_posting.google.com>
Date: 27 Jul 2002 15:52:44 -0700
Message-ID: <4d814faa.0207271452.5f9064da_at_posting.google.com>
While selecting into a variable like the following, how should the host variable be specified = :hostvariable or just hostvariable ?
select name into v_name where empid = 100;
OR
select name into :v_name where empid = 100;
I have seen the host variables referred to in both ways. What is the
difference ?
Does it matter if they are declared as VARIABLE or any other type ....
???
TIA Received on Sun Jul 28 2002 - 00:52:44 CEST