oracle 如果存在不创建表,oracle – 如果表不存在则创建表,并在创建后输入一行...

如果你想检查表创建

DECLARE count NUMBER;

BEGIN

count := 0;

SELECT COUNT(1) INTO count from user_tables WHERE table_name= 'MY_TABLE';

IF COL_COUNT = 0 THEN

EXECUTE IMMEDIATE 'create table ....';

END IF;

END;

/

检查DML.请注意您必须分离您的pk列和值.

DECLARE count NUMBER;

BEGIN

count := 0;

SELECT COUNT(1) INTO count from MY_TABLE WHERE id= 0 and name='Something';

IF COL_COUNT = 0 THEN

EXECUTE IMMEDIATE 'insert into MY_TABLE (id,name) values(0,''something'') ';

END IF;

END;

/

另请注意,当您插入表格时,我会重新指定列