PLSQL 笔记

建表：

CREATE TABLE HLSPROD.prj_chance_test
   (  chance_id NUMBER NOT NULL ENABLE, 
  chance_number VARCHAR2(100) NOT NULL ENABLE, 
  document_type VARCHAR2(2000),
  document_category VARCHAR2(2000)
   )

create sequence prj_chance_test_s;
 
select * from prj_chance_test 

create or replace package TFY_TEST_PLSQL_PKG is

  -- Author  : ADMINISTRATOR
  -- Created : 2017/5/31 17:06:41
  -- Purpose : plsql练习
  
 /**
   * TFY_TEST1 
   */
  procedure insret_prj_chance_test(p_chance_number varchar2,
                                   p_doc_t varchar2,
                                   p_doc_g varchar2);
end TFY_TEST_PLSQL_PKG;

create or replace package body TFY_TEST_PLSQL_PKG is

/**
  * TFY_TEST1 
  */
procedure insret_prj_chance_test(p_chance_number varchar2,p_doc_t varchar2,p_doc_g varchar2) is
v_id number;
begin
 v_id:= prj_chance_test_s.nextval;
 insert into prj_chance_test(chance_id,chance_number,document_type,document_category)
 values(
 	v_id,p_chance_number,p_doc_t,p_doc_g
 );
end;

end TFY_TEST_PLSQL_PKG;

declare
v_id number;
begin
  TFY_TEST_PLSQL_PKG.insret_prj_chance_test(p_chance_number=>'111',p_doc_t=>'222',p_doc_g =>'333');
end;