生活随笔
收集整理的這篇文章主要介紹了
oracle 数组类型
小編覺(jué)得挺不錯(cuò)的,現(xiàn)在分享給大家,幫大家做個(gè)參考.
?http://fxz-2008.iteye.com/blog/469766
oracle數(shù)組例子
Oracle
Pl/sql代碼 ?
--固定數(shù)組 ??declare ????type?type_array?is?varray(10)?of?varchar2(20); ????var_array?type_array:=type_array('ggs','jjh','wsb','csl','dd','bb'); ??begin ????for?i?in?1..var_array.count?loop ????????dbms_output.put_line(var_array(i)); ????end?loop; ??end; ????--可變數(shù)組 ??declare? ????type?type_array?is?table?of?varchar2(20)?index?by?binary_integer; ????var_array?type_array; ??begin? ????var_array(1):='aa'; ????var_array(2):='bb'; ???? ????for?i?in?1..var_array.count?loop ???????dbms_output.put_line(?var_array(i)); ????end?loop; ???? ??end; ????--可變數(shù)組取表 ??declare ??begin ???? ??end; ????create?or?replace?procedure?proc_stock(n?number) ??as????? ?????????var_stock_code?varchar2(10); ?????????var_stock_price?number; ??begin ?????????for?i?in?1..n?loop ?????????????var_stock_code:=?lpad(STR1?=>i?,LEN?=>6?,PAD?=>'0'?)?; ????????????? ?????????????var_stock_price:=trunc(dbms_random.value*100)+1; ?????????????--dbms_output.put_line(var_stock_code); ?????????????--dbms_output.put_line(var_stock_price); ?????????????insert?into?t_stock?(stockcode,stockprice)? ????????????????????values(var_stock_code,var_stock_price); ?????????????commit;??????? ?????????end?loop; ??end; ??declare ??begin ?????????proc_stock(1000000); ??end; ??--用游標(biāo)訪(fǎng)問(wèn)?14.578秒?13.5?13.8??declare ?????????cursor?cur?is?select?*?from?t_stock; ?????????row_stock?t_stock%rowtype; ??begin ?????????open?cur; ?????????loop? ??????????????fetch?cur?into?row_stock; ??????????????exit?when?cur%notfound; ??????????????null; ?????????end?loop; ?????????close?cur; ??end; ????--用數(shù)組實(shí)現(xiàn)?4.813?1.953?2??declare ?????????type?type_array?is?table?of?t_stock%rowtype?index?by?binary_integer; ?????????var_array?type_array; ??begin ?????????select?*?bulk?collect?into?var_array?from?t_stock; ?????????for?i?in?1..var_array.count?loop?????????? ?????????????null; ?????????end?loop; ??end; ????--訪(fǎng)問(wèn)自定義表 ??declare ?????????type?type_record?is?record( ??????????????username?varchar2(20), ??????????????sex?varchar2(2) ?????????); ?????????type_record_user??type_record; ?????????type?type_array?is?table?of?type_record_user%type?index?by?binary_integer; ?????????var_array?type_array;??????? ??begin ?????????select?username,sex?bulk?collect?into?var_array?from?tuser; ?????????for?i?in?1..var_array.count?loop ?????????????dbms_output.put_line(var_array(i).username); ?????????????dbms_output.put_line(var_array(i).sex); ?????????end?loop; ??end;??
?
與50位技術(shù)專(zhuān)家面對(duì)面20年技術(shù)見(jiàn)證，附贈(zèng)技術(shù)全景圖
總結(jié)
以上是生活随笔為你收集整理的oracle 数组类型的全部?jī)?nèi)容，希望文章能夠幫你解決所遇到的問(wèn)題。
如果覺(jué)得生活随笔網(wǎng)站內(nèi)容還不錯(cuò)，歡迎將生活随笔推薦給好友。
