Oracle数据类型

VARCH AR2
NUMBER
DATE
TIMESTAMP
CHAR
LONG
BOOLEAN
INT




DECLARE
myemp EMP%ROWTYPE;
BEGIN
SELECT * INTO myemp FROM emp WHERE empno=7934;
dbms_output.put_line(myemp.ename);
END;




DECLARE
sal emp.sal%TYPE;
mysal number(4):=3000;
totalsal mysal%TYPE;
BEGIN
SELECT SAL INTO sal FROM emp WHERE empno=7934;
totalsal:=sal+mysal;
dbms_output.put_line(totalsal);
END;