declare
v_name varchar2(50) := 'My name is yangliqiang!';
begin
dbms_output.put_line(v_name);
end;
上面这种方式是声明变量的同时对变量进行初始化
declare
v_name varchar2(50);
begin
v_name := 'My name is yangliqiang!';
dbms_output.put_line(v_name);
end;
上面这种方式是声明变量与对变量的初始化分开进行
v_name varchar2(50) := 'My name is yangliqiang!';
begin
dbms_output.put_line(v_name);
end;
上面这种方式是声明变量的同时对变量进行初始化
declare
v_name varchar2(50);
begin
v_name := 'My name is yangliqiang!';
dbms_output.put_line(v_name);
end;
上面这种方式是声明变量与对变量的初始化分开进行