c
create or replace procedure TestCS(x1 in varchar2,x2 in varchar2,x3 in varchar2) --传递参数及类型
is
sql1 varchar2;–定义参数及类型
sql2 number;
begin
书写 SQL 执行语句;
sql1:=select sysdate from dual;
判断语句
if sql1 is not null then
sql2:=select count(1) from dual;
执行sql或者其他语句
end if;
commit;
end TestCS;