20230207

string repTN_tmp = "";

//一時テーブル作成
strSql = 
    "create table " + repTN_tmp + 
    " as select * from " + xbbTN + 
    " where rownum = 1";

//更新行だけインサート
strSql = 
    "insert into " + repTN_tmp + 
    " select * from " + xbbTN + 
    " where R.KOUSHINBI >= " + repMaxUP;


string todate_xbbUP = "to_date(X.KOUSHINBI,'YYYY/MM/DD HH24:MI:SS')";
string todate_xbbMaxUP = "to_date(MAX(X.KOUSHINBI),'YYYY/MM/DD HH24:MI:SS')";
string todate_repMaxUP = "to_date('" + repMaxUP + "','YYYY/MM/DD HH24:MI:SS')";

//2テーブル限定
if (repTN = "R_" || repTN = "")
{
    strSql = 
        "select " + todate_xbbMaxUP + " from " + xbbTN +
        " where " + todate_xbbUP + " >= " + todate_repMaxUP;
    // dt = DBA(strSql);
}
else
{
    strSql = 
        "select MAX(X.KOUSHINBI) from " + xbbTN +
        " where X.KOUSHINBI" + " >= " + todate_repMaxUP;
    // dt = DBA(strSql);
}

//6:30,12:30
pravate void DeleteInsert()
{

}