Skip to content

Instantly share code, notes, and snippets.

@JubbaSmail
Created December 22, 2014 23:12
Show Gist options
  • Save JubbaSmail/18ec2bbdd56baab6fc86 to your computer and use it in GitHub Desktop.
Save JubbaSmail/18ec2bbdd56baab6fc86 to your computer and use it in GitHub Desktop.
declare
--x varchar(20);
x customers.cust_first_name %type;
y customers.cust_last_name %type;
z customers.gender %type;
begin
x:='Hello';
select cust_first_name,cust_last_name,gender
into x,y,z
from customers where customer_id = 205;
dbms_output.put_line(x|| ' ' || y || ' ' || z);
end;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment