一个简单的存储过程：
create or replace procedure
insert_user_procedure (id in number,name in varchar2,salary in number,result out varchar2)
is begin
insert into t_user values(id,name,salary);
result:=‘调用存储过程成功‘;
Exception
when others then
result:= ‘调用存储过程出错: ‘ || SQLERRM;
end;
call insert_user_procedure(?,?,?,?)
通过数据字典查询：
select table_name from user_tables;//查询表
select sequence_name from user_sequences;//查询序列
select index_name from user_indexs;//查询索引