declare
v_countnumber;
begin
selectcount(1)
intov_count
fromuser_tablest
wheret.TABLE_NAME='TSHAREDETAIL_LIQ_BAK';
ifv_count>0then
executeimmediate'droptableTSHAREDETAIL_LIQ_BAK';
endif;
executeimmediate'createtableTSHAREDETAIL_LIQ_BAKasselect*fromTSHAREDETAIL_LIQ';
end;
原文链接：https://www.f2er.com/oracle/213662.html