20230209

public void OraDropCreate(string TN)
        {
            DataTable dt = new DataTable();
            Console.WriteLine("実行...\r\n");

            try
            {
                //Drop
                strSql_DRP = "drop table " + TN + "_BK";
                Console.WriteLine("drop実行...");

                strSql = strSql_DRP;
                Console.WriteLine(strSql);
                DBA_non_dt(strSql);

                Console.WriteLine("drop完了\r\n");

                //5秒停止
                Thread.Sleep(5000);

                //Create
                strSql_CRET = "create table " + TN + "_BK as select * from " + TN;
                Console.WriteLine("creat実行...");

                strSql = strSql_CRET;
                Console.WriteLine(strSql);
                DBA_non_dt(strSql);

                Console.WriteLine("create完了\r\n");

            }
            catch (Exception ex)
            {
                Console.WriteLine(ex.Message);
                Console.WriteLine("テーブルを確認してください\r\n");

                //Create
                strSql_CRET = "create table " + TN + "_BK as select * from " + TN;
                Console.WriteLine(creTN + "creat実行...");

                strSql = strSql_CRET;
                Console.WriteLine(strSql);
                DBA_non_dt(strSql);

                Console.WriteLine(creTN + "create完了\r\n");
            }

public void DBA_non_dt(string strSql)
        {
            //接続文字列
            string strConn =
                "User Id=SCOTT;" +
                "Password=tiger;" +
                "Data Source=" +
                 "(DESCRIPTION = " +
                 "(ADDRESS = (PROTOCOL = TCP)(HOST = mypcwin)(PORT = 1521))" +
                 "(CONNECT_DATA = " +
                  "(SERVER = DEDICATED) " +
                  "(SERVICE_NAME = XEPDB1)))";

            //DataTable dt = new DataTable();//データテーブル
            using (OracleConnection conn = new OracleConnection(strConn))
            using (OracleCommand cmd = new OracleCommand(strSql, conn))
            //using (var da = new OracleDataAdapter(cmd))
            {
                conn.Open();
                cmd.ExecuteNonQuery();
                Console.WriteLine("SQL実行\r\n");
                //da.Fill(dt);
            }
            //return dt;
            //dataGridView1.DataSource = dt; //グリッドビューにデータ表示
        }