Oracle PL/SQL Grammar

Procedure:

create [or replace] procedure pname[(parameter p_pname)]
is
[……]
begin
[……]
[exception]
end [pname];
/

Function:

create [or replace] function fname[(parameter p_pname)]
return datatype
is
[……]
begin
[……]
[exception]
end [fname];
/

Trigger:

create [or replace] trigger tname
before/after insert or update[of column] or delete on table
[for each row]
[declare]
begin
[……]
[exception]
end;
/

《Oracle PL/SQL Grammar》有2条留言

留下评论