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条评论

发表评论