DECLARE
TYPE REG_VARRAY_TYPE is VARRAY(5) OF VARCHAR2(25);
v_reg_varray REG_VARRAY_TYPE;
BEGIN
V_REG_VARRAY := REG_VARRAY_TYPE('中国',
'瑞士',
'每个',
'应该',
'日本');
dbms_output.put_line('地区名称' || v_reg_varray(1) || 'dfadf' ||
v_reg_varray(2));
END;
DECLARE
v_empno emp.employee_id%type := &no;
rec
emp%rowtype;
BEGIN
select e.* into rec from emp e where e.employee_id = v_empno;
dbms_output.put_line('姓名' || rec.employee_id || rec.first_name);
END;
行类型
<script type="text/javascript" id="wumiiRelatedItems"> </script>
转发至微博
转发至微博