Oracle数据库建表前,先判断是否表存在,存在不建表,不存在则建表
------创建TABNAME ----------DECLARE TOTAL INT := 0;BEGIN SELECT COUNT(1) INTO TOTAL FROM USER_TABLES A WHERE A.TABLE_NAME = 'TABNAME '; IF TOTAL > 0 THEN EXECUTE IMMEDIATE 'DRO...