PL/SQL ... Anybody?

[chrisostomos]

Hi

Im trying to learn some PL/SQL here and I was just wondering if anyone knew how to save the result of a query into a variable.
For example

SELECT userName FROM userTable WHERE userID = 1;

and save that into a variable called user_name

Thanks
Chris Drogaris

[Toby B.]

Google is a wonderful tool....

PL/SQL Tutorials
http://www.ilook.fsnet.co.uk/ora_sql/sqlmain2.htm

[Roach412]

ooooyeah...this is my job.

SELECT userName
into user_name
FROM userTable
WHERE userID = 1;

it's actually better to use cursors, and you'll definitely want to look into those as early as you can, it makes things VERY easy later on :

Code: Select all

declare
v_user_name varchar2(20);
cursor userName is
SELECT userName
FROM userTable
WHERE userID = 1;

begin
open userName;
fetch userName into v_user_name;
close userName;
dbms_output.put_line('User name is: ' || v_user_name);

end;
/

-Roach