declare
my_name VARCHAR2(10):='张三';
begin
if length(my_name)<=2 THEN
dbms_output.put_line('我的名字是两个字!');
end;
缺少'end if;'
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;