declare cnt number; begin# v7 |9 S" `* g- _. v4 {
---发芽要建树的表是否存在9 N" M! M% x1 |. {' v( A
select count(*)into cnt from user_tables where table_name='ENTRY_MODIFYSTATUS';- F" G/ ^4 R& {6 w7 N: ^ ]+ L
---如不美观存在则删除该表
) M5 v( I; Y9 j* ~. ]7 Y if cnt>0 then6 L- J4 c( y# Z8 J
dbms_output.put_line('表存在不建树');
' L" _7 J' o, J) X else
0 K& v9 P/ N8 R7 ?5 K( a" o( Q6 h dbms_output.put_line('表不存在'); W6 w0 D# b) l& ~( J
execute immediate 'create table ENTRY_MODIFYSTATUS (4 w* p6 v8 O- t3 J% h" K
ENTRY_ID VARCHAR2(18) not null,
: F @% `% X* @2 J& X: E APPLY_TIME DATE not null,
; b# f V7 @* z$ }: V STATUS NUMBER(2),
Q$ D1 K/ Y# T3 @+ o2 @% m% u% J2 w constraint PK_ENTRY_MODIFYSTATUS primary key (ENTRY_ID, APPLY_TIME)1 b; H* U$ O5 S6 F c3 t( S
)';) V9 ^0 t' ^7 z4 z8 X5 f1 \
end if;" M, L' |9 G g4 Z4 f" `5 e
cnt:=0;( J! j8 z+ S! W3 D
end; |