存储过程与Oracle中常见的数据字典的用法

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;//查询索引

存储过程与Oracle中常见的数据字典的用法

标签：cal   varchar   str   tables   strong   过程   arch   exception   enc