示例1:
DECLARE
V_NAME varchar2(20) := ‘郭老师’;
BEGIN
DBMS_OUTPUT.put_line(V_NAME||‘的第一条PL/SQL语句’);
END;
示例2:
DECLARE
v_name1 varchar2(32);
v_name2 varchar2(32) := ‘ABC’;
v_num1 number := 13;
v_num2 number;
BEGIN
dbms_output.put_line(v_name1);
dbms_output.put_line(v_name1 || v_name2);
dbms_output.put_line(v_num1);
dbms_output.put_line(v_num1 + v_num2);
END;
注意:
1. 声明变量时,必须要指定类型
2. 变量名需要先赋值,后使用
3. 变量名没有默认值(表现是空,无意义)
示例3:
CONSTANT 定义常量值,定义后无法修改
DECLARE
v_number1 number := 13;
v_number2 CONSTANT number := 3.14;
BEGIN
DBMS_OUTPUT.put_line(v_number1 * v_number2);
END;
示例4:
变量与指定的列的类型一致 采用%TYPE
DECLARE
v_num1 employees.salary%type := 13.234;
v_num2 employees.manager_id%type := 2;