1.存储过程语法 craete or replace procedure test_proc(param1 in varchar2(10), param2 varchar2(10) as begin insert into B select .. end test_proc; 2. 关键是要的奇数列,是吧: 用CURSOR取也行,用别的方法弄出来也行,下面是取奇数列名的基本语句: select * from user_tab_cols where table_name = 'TEST_YIXL' and mod(column_id,2) = 1;
craete or replace procedure test_proc(param1 in varchar2(10), param2 varchar2(10)
as
begin
insert into B select ..
end test_proc;
2. 关键是要的奇数列,是吧:
用CURSOR取也行,用别的方法弄出来也行,下面是取奇数列名的基本语句:
select * from user_tab_cols where table_name = 'TEST_YIXL' and mod(column_id,2) = 1;