如何使用oracle临时表?V_N:=INSTR(P_HTLB,','); While V_HTLB IS NOT NULL LOOP V_HTLBA:=substring(P_HTLB,1,V_N-1); V_HTLB:=SUBSTR(V_HTLB,-(LENGTH(V_HTLB)-V_N)); Insert Into TEMP_MHTLB Select V_HTLBA FROM DUAL; V_N:=INSTR(P_HTLB,','); end LOOP;select aa.HTLBmc,b.HTLB from aa a,TEMP_MHTLB b where a.HTLB=b.HTLB THIS TEMP_MHTLB IS 我CREATE,ORACEL临时表是不是象SQL SERVER一样在过程中可以定义表,列类型使用完后,自动释放,能不能举个例子?
While V_HTLB IS NOT NULL
LOOP
V_HTLBA:=substring(P_HTLB,1,V_N-1);
V_HTLB:=SUBSTR(V_HTLB,-(LENGTH(V_HTLB)-V_N));
Insert Into TEMP_MHTLB Select V_HTLBA FROM DUAL;
V_N:=INSTR(P_HTLB,',');
end LOOP;select aa.HTLBmc,b.HTLB from aa a,TEMP_MHTLB b where a.HTLB=b.HTLB THIS TEMP_MHTLB IS 我CREATE,ORACEL临时表是不是象SQL SERVER一样在过程中可以定义表,列类型使用完后,自动释放,能不能举个例子?