%TYPE声明变量 CREATE OR REPLACE PROCEDURE testvastbase() is sss emp.ename%TYPE; BEGIN SELECT ENAME INTO sss FROM EMP LIMIT 1 ; RAISE NOTICE '%',sss; END; / vastbase=# call testvastbase(); NOTICE: SMITH testvastbase ------------- (1 row)
