如果不在架构中，则创建表；如果创建了表，则插入

本文介绍了如果不在架构中，则创建表；如果创建了表，则插入的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

我想插入模式.首先检查该表是否存在，然后插入该表，否则创建表并插入该表.您的建议对于继续执行此代码非常重要. br/> 这是我做过bt的代码，哪里有错误和错误，请plz在pl/sql中帮助我

i want to insert into schema .first check in schema where that table exists or not if there exists then insert into that table otherwise create table and insert into that table .your suggestion is very important to move ahead for this code . this is code i have done bt where is error and mistake plz help me in pl/sql

CREATE OR REPLACE PROCEDURE insert1(stringin IN VARCHAR2,value1 IN VARCHAR2,value2 IN VARCHAR2) IS val VARCHAR2(20); val2 VARCHAR2(20); val3 VARCHAR(20); BEGIN IF NOT EXISTS (SELECT 1 FROM all_tables WHERE owner = ''HR'') THEN val3:=''CREATE TABLE stringin(value1 VARCHAR2(20), value2 VARCHAR2(20)''; EXECUTE IMMEDIATE val3; BEGIN -- abc:= CREATE TABLE tbl_name (value1 VARCHAR2(20), value2 VARCHAR2(20)) ; val1:= ''INSERT INTO val3 (value1, value2) VALUES("GGG", "XYZ")''; DBMS_OUTPUT.PUT_LINE (val1); END ; ELSE BEGIN val2:='' INSERT INTO stringin (value1, value2) VALUES ("GGG", "XYZ")'' ; DBMS_OUTPUT.PUT_LINE (val2); END ; END IF ; END ;

找出

推荐答案

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[table_name]') AND type in (N'U')) CREAT TABLE ... GO