ListenSoftware解决方案“HowTo”系列2:存储过程

<script type="text/javascript"> </script> <script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script>

<script type="text/javascript"> </script><script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script>

ListenSoftware 解决方案“ HowTo” 系列2: 存储过程

 

     参照：

          参照定义和使用游标

          参照定义和使用函数

     

      存储过程

            CREATEORREPLACEPROCEDURE{procedurename}

({argument}IN{datatype})ISv_variable{datatype};

--变量类型  

       VARCHAR(X);

       VARCHAR2(X);

       VARCHAR2;

       CHAR(X);

       NUMBER(P,S);  

--P-数字的位数

       --S-数字的精度  

       NUMBER(X);

       NUMBER;

       LONG;         

       --容纳32,760字节数据

       DOUBLEPRECISION;

       FLOAT;

       INT;

       REAL;



      DATE;

       RAW(X)

       --容纳32,760字节数据

       LONGRAW;

       --容纳32,760字节数据

       --注意类型为LONGRAW

       --容纳20亿字节数据

       RECORD;

       TABLE;

       VARRAY;

       LOB;

       CLOB;

        v_variable_c1 VARCHAR2(20);           

       --创建20个字符长的变量

        v_variable_c2 CHAR(10);            

       --创建固定长度为10个字符的变量

       -最大长度255

       v_variable_c3 VARCHAR2;            

       --变量长度不能超过2000个字符

       v_variable_n1 table_name.field_name%TYPE;

       --定义参照方案中表字段类型的变量类型   

       v_variable_n2 NUMBER;

       v_variable_n3 NUMBER:=3;共3页  1  
<script type="text/javascript"> </script> <script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script>

<script type="text/javascript"> </script><script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script>