Oracle PL/SQL语法

/*
declare
说明部分 （变量说明， 光标申明， 例外说明）
begin
语句序列 (D1\.1L语句）
exception
例外处理语句
End;
*/
declare
  i varchar2(10) := 'xxx'; -赋值
begin
  dbms_output.put_line(i); -- 输出
end;
  
declare
  vrow emp%rowtype;
begin
  select * into vrow from emp where emp.empno=7788;
  dbms_output.put_line('姓名' || vrow.ename||'薪水'||vrow.sal);
end;

declare
   i varchar2(20) := 'lsq';
begin
   dbms_output.put_line(i);
end;

select * from emp;

declare
  aaa emp%rowtype;
begin
  select * into aaa from emp where emp.ename='KING';
  dbms_output.put_line(aaa.ename||aaa.empno||aaa.sal);
end;


declare
  age number :=&x;
begin
  if age<18 then 
    dbms_output.put_line('小孩');
  elsif age<=24 and age>=18 then
    dbms_output.put_line('年轻人');
  elsif age<=45 and age>=24 then
    dbms_output.put_line('老司机');
  else
    dbms_output.put_line('乐乐');
  end if;  
end;


declare
  i number :=1;
begin
  while i<=10 loop
    dbms_output.put_line(i);
    i:=i+1;
    end loop;
end;

-- reverse 反向

-- if
declare 
  i number := &m;
begin
  if i<18 then
    dbms_output.put_line('弟弟');
  elsif i<24 and i>=18 then
    dbms_output.put_line('lala');
  elsif i<40 and i>=24 then
    dbms_output.put_line('asdas');
  elsif i<60 and i>=40 then
    dbms_output.put_line('qqq');
  else
    dbms_output.put_line('zzzz');
  end if;
end;

-- 输出1-10
-- while
declare
  i number := 1;
begin
  while i<=10 loop
    dbms_output.put_line(i);
    i := i+1;
  end loop;
end;

-- do while
declare
  i number := 1;
begin
  loop
    exit when i>10;
    dbms_output.put_line(i);
    i := i+1;
  end loop;
end;
-- for
declare
begin
  for i in reverse 1..10 loop
    dbms_output.put_line(i);
  end loop;
end;