如果不在架构中，则创建表；如果创建了表，则插入 [英] create table if not in schema ,if created table then insert

问题描述

我想插入模式.首先检查该表是否存在，然后插入该表，否则创建表并插入该表.您的建议对于继续执行此代码非常重要. 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

这篇关于如果不在架构中，则创建表；如果创建了表，则插入的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！