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) isv_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;

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