有关pl/sql编程的简单问题

Question

 declare 
  my_name VARCHAR2(10):='张三';
begin
  if length(my_name)<=2 THEN
    dbms_output.put_line('我的名字是两个字!');
end;

Answer 1

缺少'end if;'

Answer 2

 declare
  type v_record is RECORD
  (
    v_name emp.ename% TYPE;
    v_salary emp.sal% TYPE;
    v_job emp.job% TYPE;
    v_deptno emp.deptno% TYPE;
  );
  staff v_record;
begin
  select ename,sal,job,deptno into staff from emp where empno=7788;
  dbms_output.put_line(staff.v_name||' '||staff.v_salary||' '||staff.v_job||' '||staff.v_deptno);
end;