摘要:
create or replace procedure up8000(table_num in number) is i number(4, 0) := 0; j number(3, 0) := 1; smstable varchar2(32); update_sql varchar2(1000); --TYPE temp_ar... 阅读全文
摘要:
发表人:chance2000 | 发表时间: 2006年七月17日, 11:23 SET SERVEROUTPUT ONDECLARETYPE T_ARRAY IS TABLE OF VARCHAR2(10) INDEX BY BINARY_INTEGER;T T_ARRAY;BEGINT(1) := 'A';T(2) := 'B';T(3) := 'C';FOR I IN 1..T.COUN... 阅读全文
摘要:
1create or replace procedure upstat(tablename in varchar2, 2 orderservid in varchar2, 3 table_num in number, 4 ... 阅读全文
摘要:
现有数据为:200001 1000200002 1100200003 1200200004 1300200005 1400200006 1500200007 1600200101 1100200202 1200200301 1300 想要转化为以下结... 阅读全文
![](/skins/gray/images/separator.gif)