开始于--,一直到行为结束,例子如下所示: DECLARE howmany NUMBER; num_tables NUMBER; BEGIN -- Begin processing
GBase 8s PL/SQL手册 南大通用数据技术股份有限公司 - 6 - SELECT COUNT(*) INTO howmany FROM USER_OBJECTS WHERE OBJECT_TYPE = 'TABLE'; -- Check number of tables num_tables := howmany; -- Compute some other value END;