sunhaijingxiaohai的专栏

oracle字符型数值不加引号,字符类型存数字

引用型变量 declare v_name table.ename%TYPE; v_sal table.sal%TYPE; begin select ename,sal into v_name,v_sal from table where id=1; dbms_output.put_line('姓名:'||v_name||',薪资:'||v_sal); end; 记录型变量 declare v_tablerow table%ROWTYPE; begin ...