SafeNet DataSecure 복호화 SQL 샘플

// 복호화

SELECT "ing_row_id",
       "version_new"
FROM   "ESVALI_TECH"."tb_tech_history_hasu0707_new"
WHERE  ( version_new IS NOT NULL )
ORDER  BY ing_row_id

UPDATE "ESVALI_TECH"."tb_tech_history_hasu0707_new"
SET    "version" = ingrian.Ingrawtostring(?)
WHERE  ing_row_id = ?

// 테이블 정리

SELECT ing_row_id
FROM   "ESVALI_TECH"."tb_tech_history_hasu0707_new"
ORDER  BY ing_row_id

UPDATE "ESVALI_TECH"."tb_tech_history_hasu0707_new"
SET    "customer" = ' '
WHERE  ing_row_id = ?

ALTER TABLE "ESVALI_TECH"."tb_tech_history_hasu0707_new"
  DROP COLUMN "version_new"