ORACLE存储过程关于建立复杂的数据类型
来源:互联网 发布:淘淘商城项目源码 编辑:程序博客网 时间:2024/06/05 22:53
1)数组
STATIC数组及其初始化:
TYPE VAR ISVARRAY(2) OF VARCHAR2(100);
VAR_RECVAR := VAR(NULL,NULL);
VAR_REC(1):= 'ZHAO';
VAR_REC(2) := 'WEI';
DBMS_OUTPUT.PUT_LINE(VAR_REC(1));
DBMS_OUTPUT.PUT_LINE(VAR_REC(2));
<!-- /* Font Definitions */ @font-face{font-family:"MS Mincho";panose-1:2 2 6 9 4 2 5 8 3 4;mso-font-alt:"MS 明朝";mso-font-charset:128;mso-generic-font-family:modern;mso-font-pitch:fixed;mso-font-signature:-1610612033 1757936891 16 0 131231 0;}@font-face{font-family:"MS Gothic";panose-1:2 11 6 9 7 2 5 8 2 4;mso-font-alt:"MS ゴシック";mso-font-charset:128;mso-generic-font-family:modern;mso-font-pitch:fixed;mso-font-signature:-1610612033 1757936891 16 0 131231 0;}@font-face{font-family:Century;panose-1:2 4 6 4 5 5 5 2 3 4;mso-font-charset:0;mso-generic-font-family:roman;mso-font-pitch:variable;mso-font-signature:647 0 0 0 159 0;}@font-face{font-family:"/@MS Mincho";panose-1:2 2 6 9 4 2 5 8 3 4;mso-font-charset:128;mso-generic-font-family:modern;mso-font-pitch:fixed;mso-font-signature:-1610612033 1757936891 16 0 131231 0;}@font-face{font-family:"/@MS Gothic";panose-1:2 11 6 9 7 2 5 8 2 4;mso-font-charset:128;mso-generic-font-family:modern;mso-font-pitch:fixed;mso-font-signature:-1610612033 1757936891 16 0 131231 0;} /* Style Definitions */ p.MsoNormal, li.MsoNormal, div.MsoNormal{mso-style-parent:"";margin:0cm;margin-bottom:.0001pt;text-align:justify;text-justify:inter-ideograph;mso-pagination:none;font-size:10.5pt;mso-bidi-font-size:12.0pt;font-family:Century;mso-fareast-font-family:"MS Mincho";mso-bidi-font-family:"Times New Roman";mso-font-kerning:1.0pt;mso-fareast-language:JA;} /* Page Definitions */ @page{mso-page-border-surround-header:no;mso-page-border-surround-footer:no;}@page Section1{size:612.0pt 792.0pt;margin:72.0pt 90.0pt 72.0pt 90.0pt;mso-header-margin:36.0pt;mso-footer-margin:36.0pt;mso-paper-source:0;}div.Section1{page:Section1;}-->
DYNAMIC数组及其初始化:
TYPEMTKENGEN IS TABLE OF PLS_INTEGER ;
FOR IXIN 1..20 LOOP
MKENGEN(IX) := 0 ;
END LOOP;
2)表
<!-- /* Font Definitions */ @font-face{font-family:"MS Mincho";panose-1:2 2 6 9 4 2 5 8 3 4;mso-font-alt:"MS 明朝";mso-font-charset:128;mso-generic-font-family:modern;mso-font-pitch:fixed;mso-font-signature:-1610612033 1757936891 16 0 131231 0;}@font-face{font-family:"MS Gothic";panose-1:2 11 6 9 7 2 5 8 2 4;mso-font-alt:"MS ゴシック";mso-font-charset:128;mso-generic-font-family:modern;mso-font-pitch:fixed;mso-font-signature:-1610612033 1757936891 16 0 131231 0;}@font-face{font-family:Century;panose-1:2 4 6 4 5 5 5 2 3 4;mso-font-charset:0;mso-generic-font-family:roman;mso-font-pitch:variable;mso-font-signature:647 0 0 0 159 0;}@font-face{font-family:"/@MS Mincho";panose-1:2 2 6 9 4 2 5 8 3 4;mso-font-charset:128;mso-generic-font-family:modern;mso-font-pitch:fixed;mso-font-signature:-1610612033 1757936891 16 0 131231 0;}@font-face{font-family:"/@MS Gothic";panose-1:2 11 6 9 7 2 5 8 2 4;mso-font-charset:128;mso-generic-font-family:modern;mso-font-pitch:fixed;mso-font-signature:-1610612033 1757936891 16 0 131231 0;} /* Style Definitions */ p.MsoNormal, li.MsoNormal, div.MsoNormal{mso-style-parent:"";margin:0cm;margin-bottom:.0001pt;text-align:justify;text-justify:inter-ideograph;mso-pagination:none;font-size:10.5pt;mso-bidi-font-size:12.0pt;font-family:Century;mso-fareast-font-family:"MS Mincho";mso-bidi-font-family:"Times New Roman";mso-font-kerning:1.0pt;mso-fareast-language:JA;} /* Page Definitions */ @page{mso-page-border-surround-header:no;mso-page-border-surround-footer:no;}@page Section1{size:612.0pt 792.0pt;margin:72.0pt 90.0pt 72.0pt 90.0pt;mso-header-margin:36.0pt;mso-footer-margin:36.0pt;mso-paper-source:0;}div.Section1{page:Section1;}-->TYPE ARR_USER_ID IS TABLEOF CHAR(10) INDEX BY BINARY_INTEGER;
TYPEARR_USER_NM IS TABLE OF VARCHAR2(20) INDEX BYBINARY_INTEGER;
<!-- /* Font Definitions */ @font-face{font-family:"MS Mincho";panose-1:2 2 6 9 4 2 5 8 3 4;mso-font-alt:"MS 明朝";mso-font-charset:128;mso-generic-font-family:modern;mso-font-pitch:fixed;mso-font-signature:-1610612033 1757936891 16 0 131231 0;}@font-face{font-family:"MS Gothic";panose-1:2 11 6 9 7 2 5 8 2 4;mso-font-alt:"MS ゴシック";mso-font-charset:128;mso-generic-font-family:modern;mso-font-pitch:fixed;mso-font-signature:-1610612033 1757936891 16 0 131231 0;}@font-face{font-family:Century;panose-1:2 4 6 4 5 5 5 2 3 4;mso-font-charset:0;mso-generic-font-family:roman;mso-font-pitch:variable;mso-font-signature:647 0 0 0 159 0;}@font-face{font-family:"/@MS Mincho";panose-1:2 2 6 9 4 2 5 8 3 4;mso-font-charset:128;mso-generic-font-family:modern;mso-font-pitch:fixed;mso-font-signature:-1610612033 1757936891 16 0 131231 0;}@font-face{font-family:"/@MS Gothic";panose-1:2 11 6 9 7 2 5 8 2 4;mso-font-charset:128;mso-generic-font-family:modern;mso-font-pitch:fixed;mso-font-signature:-1610612033 1757936891 16 0 131231 0;} /* Style Definitions */ p.MsoNormal, li.MsoNormal, div.MsoNormal{mso-style-parent:"";margin:0cm;margin-bottom:.0001pt;text-align:justify;text-justify:inter-ideograph;mso-pagination:none;font-size:10.5pt;mso-bidi-font-size:12.0pt;font-family:Century;mso-fareast-font-family:"MS Mincho";mso-bidi-font-family:"Times New Roman";mso-font-kerning:1.0pt;mso-fareast-language:JA;} /* Page Definitions */ @page{mso-page-border-surround-header:no;mso-page-border-surround-footer:no;}@page Section1{size:612.0pt 792.0pt;margin:72.0pt 90.0pt 72.0pt 90.0pt;mso-header-margin:36.0pt;mso-footer-margin:36.0pt;mso-paper-source:0;}div.Section1{page:Section1;}-->TYPE REC_USER_TYPE IS RECORD(
USER_ID ARR_USER_ID,
USER_NM ARR_USER_NM
);
<!-- /* Font Definitions */ @font-face{font-family:"MS Mincho";panose-1:2 2 6 9 4 2 5 8 3 4;mso-font-alt:"MS 明朝";mso-font-charset:128;mso-generic-font-family:modern;mso-font-pitch:fixed;mso-font-signature:-1610612033 1757936891 16 0 131231 0;}@font-face{font-family:"MS Gothic";panose-1:2 11 6 9 7 2 5 8 2 4;mso-font-alt:"MS ゴシック";mso-font-charset:128;mso-generic-font-family:modern;mso-font-pitch:fixed;mso-font-signature:-1610612033 1757936891 16 0 131231 0;}@font-face{font-family:Century;panose-1:2 4 6 4 5 5 5 2 3 4;mso-font-charset:0;mso-generic-font-family:roman;mso-font-pitch:variable;mso-font-signature:647 0 0 0 159 0;}@font-face{font-family:"/@MS Mincho";panose-1:2 2 6 9 4 2 5 8 3 4;mso-font-charset:128;mso-generic-font-family:modern;mso-font-pitch:fixed;mso-font-signature:-1610612033 1757936891 16 0 131231 0;}@font-face{font-family:"/@MS Gothic";panose-1:2 11 6 9 7 2 5 8 2 4;mso-font-charset:128;mso-generic-font-family:modern;mso-font-pitch:fixed;mso-font-signature:-1610612033 1757936891 16 0 131231 0;} /* Style Definitions */ p.MsoNormal, li.MsoNormal, div.MsoNormal{mso-style-parent:"";margin:0cm;margin-bottom:.0001pt;text-align:justify;text-justify:inter-ideograph;mso-pagination:none;font-size:10.5pt;mso-bidi-font-size:12.0pt;font-family:Century;mso-fareast-font-family:"MS Mincho";mso-bidi-font-family:"Times New Roman";mso-font-kerning:1.0pt;mso-fareast-language:JA;} /* Page Definitions */ @page{mso-page-border-surround-header:no;mso-page-border-surround-footer:no;}@page Section1{size:612.0pt 792.0pt;margin:72.0pt 90.0pt 72.0pt 90.0pt;mso-header-margin:36.0pt;mso-footer-margin:36.0pt;mso-paper-source:0;}div.Section1{page:Section1;}-->REC_USER_TABLEREC_USER_TYPE;
- ORACLE存储过程关于建立复杂的数据类型
- Oracle 中存储过程的建立
- 复杂的 oracle 存储过程和触发器复制数据
- 复杂的存储过程例子
- 关于oracle存储过程
- 关于oracle存储过程
- 关于oracle存储过程的若干问题备忘
- 关于oracle存储过程的若干问题备忘
- 关于oracle存储过程的若干问题备忘
- 关于oracle存储过程的若干问题备忘
- 关于oracle存储过程的问题
- 关于oracle存储过程的若干问题备忘
- 关于Oracle存储过程的若干问题备忘
- 关于oracle存储过程的若干问题备忘
- oracle关于存储过程的经验
- 关于oracle存储过程的若干问题备忘
- 关于oracle存储过程的若干问题备忘
- 关于oracle存储过程的若干问题备忘
- 在页面初始化时,用JavaScript将从数据库中读取出来的日期型格式化为想要的类型。
- COM 组件设计与应用(十一)IDispatch 及双接口的调用
- 想
- SQLite Version3.3.6源代码文件结构
- Oracle XML Publisher
- ORACLE存储过程关于建立复杂的数据类型
- myeclipse连接mysql数据库错误问题解决(搞了好久才发现是这个问题)
- Spring+iBatis+JDom递归生成XML树
- SQLite入门与分析(五)---Page Cache之并发控制
- Linux 下串口编程入门
- ORACLE中事务提交和会滚过程中异常发生的处理过程
- hibernate,struts,Spring的面试笔试题
- 搭上去西藏拉萨的火车
- ORACLE中VARCHAR2、BOOLEAN、NUMBER的比较