PLSQL
分为:
1.
2.
3.
4.
异常块举例:
declare
l_text
begin
l_text:='Hello,World!';
dbms_output.put_line(l_text);
exception
when
dbms_output.put_line('We
raise;
end;
/
嵌套块举例:
declare
begin
end;
/
条件语句举例(此例丰富,用到set
set
set
set
set
prompt
accept
prompt
declare
l_num
begin
if
dbms_output.put_line('You
elsif
dbms_output.put_line('You
elsif
dbms_output.put_line('You
elsif
dbms_output.put_line('You
elsif
dbms_output.put_line('You
else
dbms_output.put_line('please
end
end;
/
修改上例执行:
set
set
set
set
prompt
accept
prompt
declare
l_num
begin
if
dbms_output.put_line('You
elsif
dbms_output.put_line('You
elsif
dbms_output.put_line('You
elsif
dbms_output.put_line('You
elsif
dbms_output.put_line('You
else
dbms_output.put_line('please
end
end;
/