PL/SQL语法学习(一)
1 块(BLOCK)
DECLARE BEGIN <<label_outer>> .....STATEMENTS..... DECLARE BEGIN <<label_inner>> .....STATEMENTS..... END; EXCEPTION END;
2 子程序
(1)过程(PROCEDUER)
CREATE PROCEDURE procedureName(param1 paramType, ..) IS BEGIN ...STATEMENTS... END;
(2)函数(FUNCTION)
CREATE FUNCTION functionName(param1 paramType, ..) RETURN returnType IS variableName variableType; BEGIN ...STATEMENT... RETURN returnValue; END;
3 复合变量
(1)记录的定义(RECORD)
DECLARE TYPE typeName IS RECORD( field1 fieldType1, .. ); varname typeName; BEGIN ...STATEMENTS... END;