📄 pl000004.htm
字号:
<html><head><title>PACKAGE PKG1</title></head><body><h1>PACKAGE PKG1</h1><ol><lh><b>Function list:</b></lh><br><br><li><a href="pl000004.htm#FCN_SEQ1_GET_NEXT1">FCN_SEQ1_GET_NEXT</a></li></ol><ol><lh><b>Procedure list:</b></lh><br><br><li><a href="pl000004.htm#PRC_21">PRC_2</a></li><li><a href="pl000004.htm#PRC_REF_CUR_TAB21">PRC_REF_CUR_TAB2</a></li></ol><ol><lh><b>Constants list:</b></lh><br><br><li><a href="pl000004.htm#GC_MAGIC_DATE1">GC_MAGIC_DATE</a></li></ol><ol><lh><b>Types list:</b></lh><br><br><li><a href="pl000004.htm#TYPE11">TYPE1</a></li></ol><ol><lh><b>Subtypes list:</b></lh><br><br><li><a href="pl000004.htm#SUBTYPE11">SUBTYPE1</a></li></ol><pre><font color="#0000A0">CREATE</font> <font color="#0000A0">OR</font> <font color="#0000A0">REPLACE</font> <font color="#0000A0">PACKAGE</font> pkg1 <font color="#0000A0">IS</font><i><font color="#804000">/* *************************************************** This is a sample of a reference cursor declared in a package*************************************************** */</i></font><a name="L7"></a><a name="TYPE11"></a><a name="TYPE11"></a><b> <font color="#0000A0">TYPE</font> type1 <font color="#0000A0">IS</font> REF <font color="#0000A0">CURSOR</font></b> /*<a href="rf000015.htm#"><b>=></b></a>*/ <font color="#0000A0">RETURN</font> <a name="REF8"></a><a href="pl000009.htm#TAB21">tab2</a>%<font color="#0000A0">ROWTYPE</font>;<i><font color="#804000">/* *************************************************** This is a sample of a subtype declared in a package*************************************************** */</i></font><a name="L14"></a><a name="SUBTYPE11"></a><b> <font color="#0000A0">SUBTYPE</font> subtype1 <font color="#0000A0">IS</font> <font color="#0000A0">CHAR</font>;</b><i><font color="#804000">/* *************************************************** This is a sample of a constant declared in a package*************************************************** */</i></font><a name="L19"></a><a name="GC_MAGIC_DATE1"></a><a name="GC_MAGIC_DATE1"></a><b> gc_magic_date <font color="#0000A0">CONSTANT</font> <font color="#0000A0">DATE</font></b> /*<a href="rf000006.htm#"><b>=></b></a>*/ := <font color="#800080">TO_DATE</font>(<font color="#008080">'10/10/1998'</font>,<font color="#008080">'MM/DD/YYYY'</font>);<i><font color="#804000">--- Returns the next value of SEQ1 </i></font><a name="L23"></a><a name="FCN_SEQ1_GET_NEXT1"></a><b> <font color="#0000A0"><a href="pl000003.htm#FCN_SEQ1_GET_NEXT1">FUNCTION</font> fcn_seq1_get_next <font color="#0000A0">RETURN</font> <font color="#0000A0">NUMBER</font>;</a></b><i><font color="#804000">/* *************************************************** This procedure returns a reference cursor pointing to a SELECT statement.*************************************************** */</i></font><a name="L30"></a><a name="PRC_REF_CUR_TAB21"></a><b> <font color="#0000A0"><a href="pl000003.htm#PRC_REF_CUR_TAB21">PROCEDURE</font> prc_ref_cur_tab2(iov_ref <font color="#0000A0">IN</font> <font color="#0000A0">OUT</font> type1);</a></b><i><font color="#804000">/* *************************************************** This procedure is a sample of how reference cursors can be used.*************************************************** */</i></font><a name="L36"></a><a name="PRC_21"></a><b> <font color="#0000A0"><a href="pl000003.htm#PRC_21">PROCEDURE</font> prc_2;</a></b><font color="#0000A0">END</font>;/</pre></body></html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -