{"id":668,"date":"2016-08-23T12:09:46","date_gmt":"2016-08-23T21:09:46","guid":{"rendered":"\/blog\/?p=668"},"modified":"2023-09-21T09:37:58","modified_gmt":"2023-09-21T00:37:58","slug":"safenet-datasecure-%ec%95%94%ed%98%b8%ed%99%94-sql-%ec%83%98%ed%94%8c","status":"publish","type":"post","link":"https:\/\/hasu0707.duckdns.org\/blog\/?p=668","title":{"rendered":"SafeNet DataSecure \uc554\ud638\ud654 SQL \uc0d8\ud50c"},"content":{"rendered":"\n

\/\/ \uceec\ub7fc \uc554\ud638\ud654<\/span><\/font><\/font><\/p>\r\n


<\/font><\/font><\/p>\r\n

\r\n<\/span>CREATE<\/span><\/font> <\/span>SEQUENCE<\/span><\/font> <\/span>\"ESVALI_TECH\"<\/span><\/font>.<\/span><\/font>\"ING_SEQ_2\"<\/span><\/font> <\/span>NOCACHE<\/span><\/font> <\/span><\/font><\/p>\r\n\r\n<\/span>


<\/font><\/font><\/p>\r\n\r\n<\/span>

lock<\/span><\/font> <\/span>TABLE<\/span><\/font> <\/span>\"ESVALI_TECH\"<\/span><\/font>.<\/span><\/font>\"TB_TECH_HISTORY_HASU0707\"<\/span><\/font> <\/span>IN<\/span><\/font> <\/span>EXCLUSIVE<\/span><\/font> <\/span>MODE<\/span><\/font> <\/span><\/font><\/p>\r\n\r\n<\/span>


ALTER<\/span><\/font> <\/span>TABLE<\/span><\/font> <\/span>\"ESVALI_TECH\"<\/span><\/font>.<\/span><\/font>\"TB_TECH_HISTORY_HASU0707\"<\/span><\/font> <\/span>ADD<\/span><\/font> <\/span>ing_row_id<\/span><\/font> <\/span>INTEGER<\/span><\/font><\/font><\/p>\r\n\r\n<\/span>


<\/font>UPDATE<\/span><\/font> <\/span>\"ESVALI_TECH\"<\/span><\/font>.<\/span><\/font>\"TB_TECH_HISTORY_HASU0707\"<\/span><\/font><\/font><\/p>\r\n\r\n<\/span>

SET<\/span><\/font>    <\/span>ing_row_id<\/span><\/font>=<\/span><\/font>\"ESVALI_TECH\"<\/span><\/font>.<\/span><\/font>ing_seq_2<\/span><\/font>.<\/span><\/font>NEXTVAL<\/span><\/font>\r\n<\/span>
WHERE<\/span><\/font>  <\/span>ROWID<\/span><\/font>=<\/span><\/font>ROWID<\/span><\/font>\r\n<\/span>

<\/font><\/font><\/p>\r\n\r\n<\/span>

CREATE<\/span><\/font> <\/span>UNIQUE<\/span><\/font> <\/span>INDEX<\/span><\/font> <\/span>\"ESVALI_TECH\"<\/span><\/font>.<\/span><\/font>ing_idx_2<\/span><\/font>\r\n<\/span>
ON<\/span><\/font> <\/span>\"ESVALI_TECH\"<\/span><\/font>.<\/span><\/font>\"TB_TECH_HISTORY_HASU0707\"<\/span><\/font>\r\n<\/span>
(<\/span><\/font>\r\n<\/span>ing_row_id<\/span><\/font>\r\n<\/span>)<\/span><\/font>\r\n<\/span>

<\/font><\/font><\/p>\r\n\r\n<\/span>

LOCK <\/span>TABLE<\/span><\/font> <\/span>\"ESVALI_TECH\"<\/span><\/font>.<\/span><\/font>\"TB_TECH_HISTORY_HASU0707\"<\/span><\/font> <\/span>IN<\/span><\/font> <\/span>EXCLUSIVE<\/span><\/font> <\/span>MODE<\/span><\/font>\r\n<\/span>

<\/font><\/font><\/p>\r\n\r\n<\/span>

ALTER<\/span><\/font> <\/span>TABLE<\/span><\/font> <\/span>\"ESVALI_TECH\"<\/span><\/font>.<\/span><\/font>\"TB_TECH_HISTORY_HASU0707\"<\/span><\/font> <\/span>ADD<\/span><\/font> <\/span>(<\/span><\/font> <\/span>\"ISSUE_NEW\"<\/span><\/font> <\/span>RAW<\/span><\/font>(<\/span><\/font>528<\/span><\/font>)<\/span><\/font> <\/span>)<\/span><\/font>\r\n<\/span>

<\/font><\/font><\/p>\r\n\r\n<\/span>

ALTER<\/span><\/font> <\/span>TABLE<\/span><\/font> <\/span>\"ESVALI_TECH\"<\/span><\/font>.<\/span><\/font>\"TB_TECH_HISTORY_HASU0707\"<\/span><\/font> <\/span>RENAME<\/span><\/font> <\/span>TO<\/span><\/font> <\/span>\"TB_TECH_HISTORY_HASU0707_NEW\"<\/span><\/font>\r\n<\/span>

<\/font><\/font><\/p>\r\n\r\n<\/span>

CREATE<\/span><\/font> <\/span>OR<\/span><\/font> <\/span>replace<\/span><\/font> <\/span>VIEW<\/span><\/font> <\/span>\"ESVALI_TECH\"<\/span><\/font>.<\/span><\/font>\"TB_TECH_HISTORY_HASU0707_IDV\"<\/span><\/font> <\/span>AS<\/span><\/font>\r\n<\/span>
SELECT<\/span><\/font> <\/span>\"INDEX\"<\/span><\/font>,<\/span><\/font>\r\n<\/span>
       <\/span>\"DATE\"<\/span><\/font>,<\/span><\/font>\r\n<\/span>
       <\/span>\"CUSTOMER\"<\/span><\/font>,<\/span><\/font>\r\n<\/span>
       <\/span>\"PRODUCT\"<\/span><\/font>,<\/span><\/font>\r\n<\/span>
       <\/span>\"VERSION\"<\/span><\/font>,<\/span><\/font>\r\n<\/span>
       <\/span>\"ISSUE\"<\/span><\/font>,<\/span><\/font>\r\n<\/span>
       <\/span>\"PROCESS\"<\/span><\/font>,<\/span><\/font>\r\n<\/span>
       <\/span>\"ETC\"<\/span><\/font>,<\/span><\/font>\r\n<\/span>
       <\/span>\"ING_ROW_ID\"<\/span><\/font>\r\n<\/span>
FROM<\/span><\/font>   <\/span>\"ESVALI_TECH\"<\/span><\/font>.<\/span><\/font>\"TB_TECH_HISTORY_HASU0707_NEW\"<\/span><\/font>\r\n<\/span>

<\/font><\/font><\/p>\r\n\r\n<\/span>

CREATE<\/span><\/font> <\/span>OR<\/span><\/font> <\/span>replace<\/span><\/font> <\/span>VIEW<\/span><\/font> <\/span>\"ESVALI_TECH\"<\/span><\/font>.<\/span><\/font>\"TB_TECH_HISTORY_HASU0707\"<\/span><\/font> <\/span>AS<\/span><\/font>\r\n<\/span>
SELECT<\/span><\/font> <\/span>\"INDEX\"<\/span><\/font> <\/span>,<\/span><\/font>\r\n<\/span>
       <\/span>\"DATE\"<\/span><\/font> <\/span>,<\/span><\/font>\r\n<\/span>
       <\/span>\"CUSTOMER\"<\/span><\/font> <\/span>,<\/span><\/font>\r\n<\/span>
       <\/span>\"PRODUCT\"<\/span><\/font> <\/span>,<\/span><\/font>\r\n<\/span>
       <\/span>\"VERSION\"<\/span><\/font> <\/span>,<\/span><\/font>\r\n<\/span>
       <\/span>\"ISSUE\"<\/span><\/font> <\/span>,<\/span><\/font>\r\n<\/span>
       <\/span>\"PROCESS\"<\/span><\/font> <\/span>,<\/span><\/font>\r\n<\/span>
       <\/span>\"ETC\"<\/span><\/font>\r\n<\/span>
FROM<\/span><\/font>   <\/span>\"ESVALI_TECH\"<\/span><\/font>.<\/span><\/font>\"TB_TECH_HISTORY_HASU0707_IDV\"<\/span><\/font> <\/span><\/font><\/p>\r\n\r\n<\/span>


<\/font><\/font><\/p>\r\n\r\n<\/span>

CREATE <\/span><\/font>OR<\/span><\/font> <\/span>replace<\/span><\/font> <\/span>TRIGGER<\/span><\/font> <\/span>\"ESVALI_TECH\"<\/span><\/font>.<\/span><\/font>\"TB_TECH_HISTORY_HASU0_INS_TRIG\"<\/span><\/font> <\/span>instead<\/span><\/font> <\/span>OF<\/span><\/font> <\/span><\/font><\/p>\r\n\r\n<\/span>

INSERT<\/span><\/font>\r\n<\/span>ON<\/span><\/font> <\/span>\"ESVALI_TECH\"<\/span><\/font>.<\/span><\/font>\"TB_TECH_HISTORY_HASU0707_IDV\"<\/span><\/font> <\/span>REFERENCING<\/span><\/font> <\/span>NEW<\/span><\/font> <\/span>AS<\/span><\/font> <\/span>NEW<\/span><\/font> <\/span>OLD<\/span><\/font> <\/span>AS<\/span><\/font> <\/span>OLD<\/span><\/font> <\/span>FOR<\/span><\/font> <\/span>EACH<\/span><\/font> <\/span>ROW<\/span><\/font> <\/span>DECLARE<\/span><\/font> <\/span>check_22<\/span><\/font> <\/span>VARCHAR2<\/span><\/font> <\/span>
<\/font><\/p>\r\n\r\n<\/span>

       <\/span>(<\/span><\/font>\r\n<\/span>
              <\/span>512<\/span><\/font>\r\n<\/span>
       <\/span>)<\/span><\/font>;<\/span><\/font>BEGIN<\/span><\/font>\r\n<\/span>
  <\/span>SELECT<\/span><\/font> <\/span>:NEW<\/span><\/font>.<\/span><\/font>\"ISSUE\"<\/span><\/font>\r\n<\/span>
  <\/span>INTO<\/span><\/font>   <\/span>check_22<\/span><\/font>\r\n<\/span>
  <\/span>FROM<\/span><\/font>   <\/span>dual<\/span><\/font>;<\/span><\/font>\r\n<\/span>
  \r\n<\/span>
  <\/span>INSERT<\/span><\/font> <\/span>INTO<\/span><\/font> <\/span>\"ESVALI_TECH\"<\/span><\/font>.<\/span><\/font>\"TB_TECH_HISTORY_HASU0707_NEW\"<\/span><\/font>\r\n<\/span>
              <\/span>(<\/span><\/font>\r\n<\/span>
                          <\/span>\"INDEX\"<\/span><\/font>,<\/span><\/font>\r\n<\/span>
                          <\/span>\"DATE\"<\/span><\/font>,<\/span><\/font>\r\n<\/span>
                          <\/span>\"CUSTOMER\"<\/span><\/font>,<\/span><\/font>\r\n<\/span>
                          <\/span>\"PRODUCT\"<\/span><\/font>,<\/span><\/font>\r\n<\/span>
                          <\/span>\"VERSION\"<\/span><\/font>,<\/span><\/font>\r\n<\/span>
                          <\/span>\"ISSUE\"<\/span><\/font>,<\/span><\/font>\r\n<\/span>
                          <\/span>\"ISSUE_NEW\"<\/span><\/font>,<\/span><\/font>\r\n<\/span>
                          <\/span>\"PROCESS\"<\/span><\/font>,<\/span><\/font>\r\n<\/span>
                          <\/span>\"ETC\"<\/span><\/font>,<\/span><\/font>\r\n<\/span>
                          <\/span>\"ING_ROW_ID\"<\/span><\/font>\r\n<\/span>
              <\/span>)<\/span><\/font>\r\n<\/span>
              <\/span>VALUES<\/span><\/font>\r\n<\/span>
              <\/span>(<\/span><\/font>\r\n<\/span>
                          <\/span>:NEW<\/span><\/font>.<\/span><\/font>\"INDEX\"<\/span><\/font>,<\/span><\/font>\r\n<\/span>
                          <\/span>:NEW<\/span><\/font>.<\/span><\/font>\"DATE\"<\/span><\/font>,<\/span><\/font>\r\n<\/span>
                          <\/span>:NEW<\/span><\/font>.<\/span><\/font>\"CUSTOMER\"<\/span><\/font>,<\/span><\/font>\r\n<\/span>
                          <\/span>:NEW<\/span><\/font>.<\/span><\/font>\"PRODUCT\"<\/span><\/font>,<\/span><\/font>\r\n<\/span>
                          <\/span>:NEW<\/span><\/font>.<\/span><\/font>\"VERSION\"<\/span><\/font>,<\/span><\/font>\r\n<\/span>
                          <\/span>:NEW<\/span><\/font>.<\/span><\/font>\"ISSUE\"<\/span><\/font>,<\/span><\/font>\r\n<\/span>
                          <\/span>ingrian<\/span><\/font>.<\/span><\/font>ingfastencryptvarcharbyname<\/span><\/font>(<\/span><\/font>:NEW<\/span><\/font>.<\/span><\/font>\"ISSUE\"<\/span><\/font>,<\/span><\/font> <\/span>'ESVALI_TECH'<\/span><\/font>,<\/span><\/font> <\/span>'TB_TECH_HISTORY_HASU0707:3'<\/span><\/font>,<\/span><\/font> <\/span>'ISSUE'<\/span><\/font>,<\/span><\/font> <\/span>'C31ECDE409E93E3B401F362BC7B0ADE1'<\/span><\/font>)<\/span><\/font>,<\/span><\/font>\r\n<\/span>
                          <\/span>:NEW<\/span><\/font>.<\/span><\/font>\"PROCESS\"<\/span><\/font>,<\/span><\/font>\r\n<\/span>
                          <\/span>:NEW<\/span><\/font>.<\/span><\/font>\"ETC\"<\/span><\/font>,<\/span><\/font>\r\n<\/span>
                          <\/span>\"ESVALI_TECH\"<\/span><\/font>.<\/span><\/font>ing_seq_2<\/span><\/font>.<\/span><\/font>NEXTVAL<\/span><\/font>\r\n<\/span>
              <\/span>)<\/span><\/font>;<\/span><\/font>\r\n<\/span>
\r\n<\/span>
END<\/span><\/font>;<\/span><\/font>\r\n<\/span>

<\/font><\/font><\/p>\r\n\r\n<\/span>

CREATE<\/span><\/font>\r\n<\/span>OR<\/span><\/font>\r\n<\/span>replace<\/span><\/font> <\/span>TRIGGER<\/span><\/font> <\/span>\"ESVALI_TECH\"<\/span><\/font>.<\/span><\/font>\"TB_TECH_HISTORY_HASU0_UPD_TRIG\"<\/span><\/font> <\/span>instead<\/span><\/font> <\/span>OF<\/span><\/font>\r\n<\/span>
UPDATE<\/span><\/font>\r\n<\/span>
ON<\/span><\/font> <\/span>\"ESVALI_TECH\"<\/span><\/font>.<\/span><\/font>\"TB_TECH_HISTORY_HASU0707_IDV\"<\/span><\/font> <\/span>REFERENCING<\/span><\/font> <\/span>NEW<\/span><\/font> <\/span>AS<\/span><\/font> <\/span>NEW<\/span><\/font> <\/span>OLD<\/span><\/font> <\/span>AS<\/span><\/font> <\/span>OLD<\/span><\/font> <\/span>FOR<\/span><\/font> <\/span>EACH<\/span><\/font> <\/span>ROW<\/span><\/font> <\/span>DECLARE<\/span><\/font> <\/span>check_22<\/span><\/font> <\/span>VARCHAR2<\/span><\/font>(<\/span><\/font>512<\/span><\/font>)<\/span><\/font>;<\/span><\/font>\r\n<\/span>
\r\n<\/span>
BEGIN<\/span><\/font>\r\n<\/span>
  <\/span>SELECT<\/span><\/font> <\/span>:NEW<\/span><\/font>.<\/span><\/font>\"ISSUE\"<\/span><\/font>\r\n<\/span>
  <\/span>INTO<\/span><\/font>   <\/span>check_22<\/span><\/font>\r\n<\/span>
  <\/span>FROM<\/span><\/font>   <\/span>dual<\/span><\/font>;<\/span><\/font>\r\n<\/span>
  \r\n<\/span>
  <\/span>UPDATE<\/span><\/font> <\/span>\"ESVALI_TECH\"<\/span><\/font>.<\/span><\/font>\"TB_TECH_HISTORY_HASU0707_NEW\"<\/span><\/font>\r\n<\/span>
  <\/span>SET<\/span><\/font>    <\/span>\"INDEX\"<\/span><\/font> <\/span>=<\/span><\/font> <\/span>:NEW<\/span><\/font>.<\/span><\/font>\"INDEX\"<\/span><\/font> <\/span>,<\/span><\/font>\r\n<\/span>
         <\/span>\"DATE\"<\/span><\/font> <\/span>=<\/span><\/font> <\/span>:NEW<\/span><\/font>.<\/span><\/font>\"DATE\"<\/span><\/font> <\/span>,<\/span><\/font>\r\n<\/span>
         <\/span>\"CUSTOMER\"<\/span><\/font> <\/span>=<\/span><\/font> <\/span>:NEW<\/span><\/font>.<\/span><\/font>\"CUSTOMER\"<\/span><\/font> <\/span>,<\/span><\/font>\r\n<\/span>
         <\/span>\"PRODUCT\"<\/span><\/font> <\/span>=<\/span><\/font> <\/span>:NEW<\/span><\/font>.<\/span><\/font>\"PRODUCT\"<\/span><\/font> <\/span>,<\/span><\/font>\r\n<\/span>
         <\/span>\"VERSION\"<\/span><\/font> <\/span>=<\/span><\/font> <\/span>:NEW<\/span><\/font>.<\/span><\/font>\"VERSION\"<\/span><\/font> <\/span>,<\/span><\/font>\r\n<\/span>
         <\/span>\"ISSUE\"<\/span><\/font> <\/span>=<\/span><\/font> <\/span>:NEW<\/span><\/font>.<\/span><\/font>\"ISSUE\"<\/span><\/font> <\/span>,<\/span><\/font>\r\n<\/span>
         <\/span>\"ISSUE_NEW\"<\/span><\/font> <\/span>=<\/span><\/font> <\/span>decode<\/span><\/font> <\/span>(<\/span><\/font>:NEW<\/span><\/font>.<\/span><\/font>\"ISSUE\"<\/span><\/font> <\/span>,<\/span><\/font>\r\n<\/span>
                               <\/span>:OLD<\/span><\/font>.<\/span><\/font>\"ISSUE\"<\/span><\/font> <\/span>,<\/span><\/font> <\/span>\"ISSUE_NEW\"<\/span><\/font> <\/span>,<\/span><\/font>\r\n<\/span>
                               <\/span>ingrian<\/span><\/font>.<\/span><\/font>ingfastencryptvarcharbyname<\/span><\/font>(<\/span><\/font>:NEW<\/span><\/font>.<\/span><\/font>\"ISSUE\"<\/span><\/font>,<\/span><\/font> <\/span>'ESVALI_TECH'<\/span><\/font>,<\/span><\/font> <\/span>'TB_TECH_HISTORY_HASU0707:3'<\/span><\/font>,<\/span><\/font> <\/span>'ISSUE'<\/span><\/font>,<\/span><\/font> <\/span>'C31ECDE409E93E3B401F362BC7B0ADE1'<\/span><\/font>)<\/span><\/font> <\/span>)<\/span><\/font> <\/span>,<\/span><\/font>\r\n<\/span>
         <\/span>\"PROCESS\"<\/span><\/font> <\/span>=<\/span><\/font> <\/span>:NEW<\/span><\/font>.<\/span><\/font>\"PROCESS\"<\/span><\/font> <\/span>,<\/span><\/font>\r\n<\/span>
         <\/span>\"ETC\"<\/span><\/font> <\/span>=<\/span><\/font> <\/span>:NEW<\/span><\/font>.<\/span><\/font>\"ETC\"<\/span><\/font>\r\n<\/span>
  <\/span>WHERE<\/span><\/font>  <\/span>ing_row_id<\/span><\/font> <\/span>=<\/span><\/font> <\/span>:OLD<\/span><\/font>.<\/span><\/font>ing_row_id<\/span><\/font>;<\/span><\/font>\r\n<\/span>
\r\n<\/span>
END<\/span><\/font>;<\/span><\/font>\r\n<\/span>
SELECT<\/span><\/font>   <\/span>ing_row_id<\/span><\/font> <\/span>,<\/span><\/font>\r\n<\/span>
         <\/span>ingrian<\/span><\/font>.<\/span><\/font>ingstringtoraw<\/span><\/font>(<\/span><\/font>\"ISSUE\"<\/span><\/font>)<\/span><\/font>\r\n<\/span>
FROM<\/span><\/font>     <\/span>\"ESVALI_TECH\"<\/span><\/font>.<\/span><\/font>\"TB_TECH_HISTORY_HASU0707_NEW\"<\/span><\/font>\r\n<\/span>
WHERE<\/span><\/font>    <\/span>(<\/span><\/font>\r\n<\/span>
                  <\/span>issue<\/span><\/font> <\/span>IS<\/span><\/font> <\/span>NOT<\/span><\/font> <\/span>NULL<\/span><\/font> <\/span>)<\/span><\/font>\r\n<\/span>
ORDER<\/span><\/font> <\/span>BY<\/span><\/font> <\/span>ing_row_id<\/span><\/font>\r\n<\/span>
UPDATE<\/span><\/font> <\/span>\"ESVALI_TECH\"<\/span><\/font>.<\/span><\/font>\"TB_TECH_HISTORY_HASU0707_NEW\"<\/span><\/font>\r\n<\/span>
SET<\/span><\/font>    <\/span>\"ISSUE_NEW\"<\/span><\/font> <\/span>=<\/span><\/font> <\/span>?<\/span><\/font>\r\n<\/span>
WHERE<\/span><\/font>  <\/span>ing_row_id<\/span><\/font> <\/span>=<\/span><\/font> <\/span>?<\/span><\/font>\r\n<\/span>
CREATE<\/span><\/font> <\/span>OR<\/span><\/font> <\/span>replace<\/span><\/font> <\/span>VIEW<\/span><\/font> <\/span>\"ESVALI_TECH\"<\/span><\/font>.<\/span><\/font>\"TB_TECH_HISTORY_HASU0707_IDV\"<\/span><\/font> <\/span>AS<\/span><\/font>\r\n<\/span>
SELECT<\/span><\/font> <\/span>\"INDEX\"<\/span><\/font>,<\/span><\/font>\r\n<\/span>
       <\/span>\"DATE\"<\/span><\/font>,<\/span><\/font>\r\n<\/span>
       <\/span>\"CUSTOMER\"<\/span><\/font>,<\/span><\/font>\r\n<\/span>
       <\/span>\"PRODUCT\"<\/span><\/font>,<\/span><\/font>\r\n<\/span>
       <\/span>\"VERSION\"<\/span><\/font>,<\/span><\/font>\r\n<\/span>
       <\/span>ingrian<\/span><\/font>.<\/span><\/font>ingfastdecryptop<\/span><\/font>(<\/span><\/font>\"ISSUE_NEW\"<\/span><\/font>,<\/span><\/font> <\/span>'ESVALI_TECH'<\/span><\/font>,<\/span><\/font> <\/span>'TB_TECH_HISTORY_HASU0707_NEW:3'<\/span><\/font>,<\/span><\/font> <\/span>'ISSUE_NEW'<\/span><\/font>,<\/span><\/font> <\/span>'C31ECDE409E93E3B401F362BC7B0ADE1'<\/span><\/font>)<\/span><\/font>\"ISSUE\"<\/span><\/font>,<\/span><\/font>\r\n<\/span>
       <\/span>\"PROCESS\"<\/span><\/font>,<\/span><\/font>\r\n<\/span>
       <\/span>\"ETC\"<\/span><\/font>,<\/span><\/font>\r\n<\/span>
       <\/span>\"ING_ROW_ID\"<\/span><\/font>\r\n<\/span>
FROM<\/span><\/font>   <\/span>\"ESVALI_TECH\"<\/span><\/font>.<\/span><\/font>\"TB_TECH_HISTORY_HASU0707_NEW\"<\/span><\/font> <\/span><\/font><\/p>\r\n\r\n<\/span>


<\/font><\/font><\/p>\r\n\r\n<\/span>

CREATE<\/span><\/font>\r\n<\/span>OR<\/span><\/font> r<\/span>eplace<\/span><\/font> <\/span>TRIGGER<\/span><\/font> <\/span>\"ESVALI_TECH\"<\/span><\/font>.<\/span><\/font>\"TB_TECH_HISTORY_HASU0_INS_TRIG\"<\/span><\/font> <\/span>instead<\/span><\/font> <\/span>OF<\/span><\/font>\r\n<\/span>
INSERT<\/span><\/font>\r\n<\/span>
ON<\/span><\/font> <\/span>\"ESVALI_TECH\"<\/span><\/font>.<\/span><\/font>\"TB_TECH_HISTORY_HASU0707_IDV\"<\/span><\/font> <\/span>REFERENCING<\/span><\/font> <\/span>NEW<\/span><\/font> <\/span>AS<\/span><\/font> <\/span>NEW<\/span><\/font> <\/span>OLD<\/span><\/font> <\/span>AS<\/span><\/font> <\/span>OLD<\/span><\/font> <\/span>FOR<\/span><\/font> <\/span>EACH<\/span><\/font> <\/span>ROW<\/span><\/font> <\/span>DECLARE<\/span><\/font> <\/span>check_22<\/span><\/font> <\/span>VARCHAR2<\/span><\/font>\r\n<\/span>
       <\/span>(<\/span><\/font>\r\n<\/span>
              <\/span>512<\/span><\/font>\r\n<\/span>
       <\/span>)<\/span><\/font>;<\/span><\/font>\r\n<\/span>
\r\n<\/span>
BEGIN<\/span><\/font>\r\n<\/span>
  <\/span>SELECT<\/span><\/font> <\/span>:NEW<\/span><\/font>.<\/span><\/font>\"ISSUE\"<\/span><\/font>\r\n<\/span>
  <\/span>INTO<\/span><\/font>   <\/span>check_22<\/span><\/font>\r\n<\/span>
  <\/span>FROM<\/span><\/font>   <\/span>dual<\/span><\/font>;<\/span><\/font>\r\n<\/span>
  \r\n<\/span>
  <\/span>INSERT<\/span><\/font> <\/span>INTO<\/span><\/font> <\/span>\"ESVALI_TECH\"<\/span><\/font>.<\/span><\/font>\"TB_TECH_HISTORY_HASU0707_NEW\"<\/span><\/font>\r\n<\/span>
              <\/span>(<\/span><\/font>\r\n<\/span>
                          <\/span>\"INDEX\"<\/span><\/font>,<\/span><\/font>\r\n<\/span>
                          <\/span>\"DATE\"<\/span><\/font>,<\/span><\/font>\r\n<\/span>
                          <\/span>\"CUSTOMER\"<\/span><\/font>,<\/span><\/font>\r\n<\/span>
                          <\/span>\"PRODUCT\"<\/span><\/font>,<\/span><\/font>\r\n<\/span>
                          <\/span>\"VERSION\"<\/span><\/font>,<\/span><\/font>\r\n<\/span>
                          <\/span>\"ISSUE\"<\/span><\/font>,<\/span><\/font>\r\n<\/span>
                          <\/span>\"ISSUE_NEW\"<\/span><\/font>,<\/span><\/font>\r\n<\/span>
                          <\/span>\"PROCESS\"<\/span><\/font>,<\/span><\/font>\r\n<\/span>
                          <\/span>\"ETC\"<\/span><\/font>,<\/span><\/font>\r\n<\/span>
                          <\/span>\"ING_ROW_ID\"<\/span><\/font>\r\n<\/span>
              <\/span>)<\/span><\/font>\r\n<\/span>
              <\/span>VALUES<\/span><\/font>\r\n<\/span>
              <\/span>(<\/span><\/font>\r\n<\/span>
                          <\/span>:NEW<\/span><\/font>.<\/span><\/font>\"INDEX\"<\/span><\/font>,<\/span><\/font>\r\n<\/span>
                          <\/span>:NEW<\/span><\/font>.<\/span><\/font>\"DATE\"<\/span><\/font>,<\/span><\/font>\r\n<\/span>
                          <\/span>:NEW<\/span><\/font>.<\/span><\/font>\"CUSTOMER\"<\/span><\/font>,<\/span><\/font>\r\n<\/span>
                          <\/span>:NEW<\/span><\/font>.<\/span><\/font>\"PRODUCT\"<\/span><\/font>,<\/span><\/font>\r\n<\/span>
                          <\/span>:NEW<\/span><\/font>.<\/span><\/font>\"VERSION\"<\/span><\/font>,<\/span><\/font>\r\n<\/span>
                          <\/span>' '<\/span><\/font>,<\/span><\/font>\r\n<\/span>
                          <\/span>ingrian<\/span><\/font>.<\/span><\/font>ingfastencryptvarcharbyname<\/span><\/font>(<\/span><\/font>:NEW<\/span><\/font>.<\/span><\/font>\"ISSUE\"<\/span><\/font>,<\/span><\/font> <\/span>'ESVALI_TECH'<\/span><\/font>,<\/span><\/font> <\/span>'TB_TECH_HISTORY_HASU0707:3'<\/span><\/font>,<\/span><\/font> <\/span>'ISSUE'<\/span><\/font>,<\/span><\/font> <\/span>'C31ECDE409E93E3B401F362BC7B0ADE1'<\/span><\/font>)<\/span><\/font>,<\/span><\/font>\r\n<\/span>
                          <\/span>:NEW<\/span><\/font>.<\/span><\/font>\"PROCESS\"<\/span><\/font>,<\/span><\/font>\r\n<\/span>
                          <\/span>:NEW<\/span><\/font>.<\/span><\/font>\"ETC\"<\/span><\/font>,<\/span><\/font>\r\n<\/span>
                          <\/span>\"ESVALI_TECH\"<\/span><\/font>.<\/span><\/font>ing_seq_2<\/span><\/font>.<\/span><\/font>NEXTVAL<\/span><\/font>\r\n<\/span>
              <\/span>)<\/span><\/font>;<\/span><\/font>\r\n<\/span>
\r\n<\/span>
END<\/span><\/font>;<\/span><\/font> <\/span><\/font><\/p>\r\n\r\n<\/span>


<\/font><\/p>\r\n\r\n<\/span>

CREATE<\/span><\/font>\r\n<\/span>OR<\/span><\/font>\r\n<\/span>replace<\/span><\/font> <\/span>TRIGGER<\/span><\/font> <\/span>\"ESVALI_TECH\"<\/span><\/font>.<\/span><\/font>\"TB_TECH_HISTORY_HASU0_UPD_TRIG\"<\/span><\/font> <\/span>instead<\/span><\/font> <\/span>OF<\/span><\/font>\r\n<\/span>
UPDATE<\/span><\/font>\r\n<\/span>
ON<\/span><\/font> <\/span>\"ESVALI_TECH\"<\/span><\/font>.<\/span><\/font>\"TB_TECH_HISTORY_HASU0707_IDV\"<\/span><\/font> <\/span>REFERENCING<\/span><\/font> <\/span>NEW<\/span><\/font> <\/span>AS<\/span><\/font> <\/span>NEW<\/span><\/font> <\/span>OLD<\/span><\/font> <\/span>AS<\/span><\/font> <\/span>OLD<\/span><\/font> <\/span>FOR<\/span><\/font> <\/span>EACH<\/span><\/font> <\/span>ROW<\/span><\/font> <\/span>DECLARE<\/span><\/font> <\/span>check_22<\/span><\/font> <\/span>VARCHAR2<\/span><\/font>(<\/span><\/font>512<\/span><\/font>)<\/span><\/font>;<\/span><\/font>\r\n<\/span>
\r\n<\/span>
BEGIN<\/span><\/font>\r\n<\/span>
  <\/span>SELECT<\/span><\/font> <\/span>:NEW<\/span><\/font>.<\/span><\/font>\"ISSUE\"<\/span><\/font>\r\n<\/span>
  <\/span>INTO<\/span><\/font>   <\/span>check_22<\/span><\/font>\r\n<\/span>
  <\/span>FROM<\/span><\/font>   <\/span>dual<\/span><\/font>;<\/span><\/font>\r\n<\/span>
  \r\n<\/span>
  <\/span>UPDATE<\/span><\/font> <\/span>\"ESVALI_TECH\"<\/span><\/font>.<\/span><\/font>\"TB_TECH_HISTORY_HASU0707_NEW\"<\/span><\/font>\r\n<\/span>
  <\/span>SET<\/span><\/font>    <\/span>\"INDEX\"<\/span><\/font> <\/span>=<\/span><\/font> <\/span>:NEW<\/span><\/font>.<\/span><\/font>\"INDEX\"<\/span><\/font> <\/span>,<\/span><\/font>\r\n<\/span>
         <\/span>\"DATE\"<\/span><\/font> <\/span>=<\/span><\/font> <\/span>:NEW<\/span><\/font>.<\/span><\/font>\"DATE\"<\/span><\/font> <\/span>,<\/span><\/font>\r\n<\/span>
         <\/span>\"CUSTOMER\"<\/span><\/font> <\/span>=<\/span><\/font> <\/span>:NEW<\/span><\/font>.<\/span><\/font>\"CUSTOMER\"<\/span><\/font> <\/span>,<\/span><\/font>\r\n<\/span>
         <\/span>\"PRODUCT\"<\/span><\/font> <\/span>=<\/span><\/font> <\/span>:NEW<\/span><\/font>.<\/span><\/font>\"PRODUCT\"<\/span><\/font> <\/span>,<\/span><\/font>\r\n<\/span>
         <\/span>\"VERSION\"<\/span><\/font> <\/span>=<\/span><\/font> <\/span>:NEW<\/span><\/font>.<\/span><\/font>\"VERSION\"<\/span><\/font> <\/span>,<\/span><\/font>\r\n<\/span>
         <\/span>\"ISSUE_NEW\"<\/span><\/font> <\/span>=<\/span><\/font> <\/span>decode<\/span><\/font> <\/span>(<\/span><\/font>:NEW<\/span><\/font>.<\/span><\/font>\"ISSUE\"<\/span><\/font> <\/span>,<\/span><\/font>\r\n<\/span>
                               <\/span>:OLD<\/span><\/font>.<\/span><\/font>\"ISSUE\"<\/span><\/font> <\/span>,<\/span><\/font> <\/span>\"ISSUE_NEW\"<\/span><\/font> <\/span>,<\/span><\/font>\r\n<\/span>
                               <\/span>ingrian<\/span><\/font>.<\/span><\/font>ingfastencryptvarcharbyname<\/span><\/font>(<\/span><\/font>:NEW<\/span><\/font>.<\/span><\/font>\"ISSUE\"<\/span><\/font>,<\/span><\/font> <\/span>'ESVALI_TECH'<\/span><\/font>,<\/span><\/font> <\/span>'TB_TECH_HISTORY_HASU0707:3'<\/span><\/font>,<\/span><\/font> <\/span>'ISSUE'<\/span><\/font>,<\/span><\/font> <\/span>'C31ECDE409E93E3B401F362BC7B0ADE1'<\/span><\/font>)<\/span><\/font> <\/span>)<\/span><\/font> <\/span>,<\/span><\/font>\r\n<\/span>
         <\/span>\"PROCESS\"<\/span><\/font> <\/span>=<\/span><\/font> <\/span>:NEW<\/span><\/font>.<\/span><\/font>\"PROCESS\"<\/span><\/font> <\/span>,<\/span><\/font>\r\n<\/span>
         <\/span>\"ETC\"<\/span><\/font> <\/span>=<\/span><\/font> <\/span>:NEW<\/span><\/font>.<\/span><\/font>\"ETC\"<\/span><\/font>\r\n<\/span>
  <\/span>WHERE<\/span><\/font>  <\/span>ing_row_id<\/span><\/font> <\/span>=<\/span><\/font> <\/span>:OLD<\/span><\/font>.<\/span><\/font>ing_row_id<\/span><\/font>;<\/span><\/font>\r\n<\/span>
\r\n<\/span>
END<\/span><\/font>;<\/span><\/font> <\/span><\/font><\/p>\r\n\r\n<\/span>


GRANT<\/span><\/font>\r\n<\/span>SELECT<\/span><\/font>\r\n<\/span>ON<\/span><\/font> <\/span>\"ESVALI_TECH\"<\/span><\/font>.<\/span><\/font>\"TB_TECH_HISTORY_HASU0707\"<\/span><\/font> <\/span>TO<\/span><\/font> <\/span>\"INGRIAN\"<\/span><\/font> <\/span><\/font><\/p>\r\n\r\n<\/span>


<\/font><\/font><\/p>\r\n\r\n<\/span>

GRANT<\/span><\/font>\r\n<\/span>SELECT<\/span><\/font>\r\n<\/span>ON<\/span><\/font> <\/span>\"ESVALI_TECH\"<\/span><\/font>.<\/span><\/font>\"TB_TECH_HISTORY_HASU0707_NEW\"<\/span><\/font> <\/span>TO<\/span><\/font> <\/span>ingrian<\/span><\/font>\r\n<\/span><\/font>\r\n<\/span><\/p>\r\n


<\/font><\/font><\/p>\r\n


<\/font><\/font><\/p>\r\n

\/\/ \ubb34\ud6a8 \ub370\uc774\ud130 \uc815\ub9ac<\/span><\/font><\/font><\/p>\r\n

SELECT<\/span><\/font> <\/span>ing_row_id<\/span><\/font> <\/span>
FROM<\/span><\/font>   <\/span>\"ESVALI_TECH\"<\/span><\/font>.<\/span><\/font>\"tb_tech_history_hasu0707_new\"<\/span><\/font> <\/span>
ORDER<\/span><\/font>  <\/span>BY<\/span><\/font> <\/span>ing_row_id<\/span><\/font> <\/span>

UPDATE<\/span><\/font> <\/span>\"ESVALI_TECH\"<\/span><\/font>.<\/span><\/font>\"tb_tech_history_hasu0707_new\"<\/span><\/font> <\/span>
SET<\/span><\/font>    <\/span>\"issue\"<\/span><\/font> <\/span>=<\/span><\/font> <\/span>' '<\/span><\/font> <\/span>
WHERE<\/span><\/font>  <\/span>ing_row_id<\/span><\/font> <\/span>=<\/span><\/font> <\/span>?<\/span><\/font>
<\/font><\/font><\/p>\r\n<\/font>

<\/div><\/div>\n","protected":false},"excerpt":{"rendered":"

\/\/ \uceec\ub7fc \uc554\ud638\ud654 CREATE SEQUENCE “ESVALI_TECH”.”ING_SEQ_2″ NOCACHE  lock TABLE “ESVALI_TECH”.”TB_TECH_HISTORY_HASU0707″ IN EXCLUSIVE MODE  ALTER TABLE “ESVALI_TECH”.”TB_TECH_HISTORY_HASU0707″ ADD ing_row_id INTEGER UPDATE “ESVALI_TECH”.”TB_TECH_HISTORY_HASU0707″ SET    ing_row_id=”ESVALI_TECH”.ing_seq_2.NEXTVAL WHERE  ROWID=ROWID CREATE UNIQUE INDEX “ESVALI_TECH”.ing_idx_2 ON “ESVALI_TECH”.”TB_TECH_HISTORY_HASU0707″ ( ing_row_id ) LOCK TABLE “ESVALI_TECH”.”TB_TECH_HISTORY_HASU0707″ IN EXCLUSIVE MODE ALTER TABLE “ESVALI_TECH”.”TB_TECH_HISTORY_HASU0707″ ADD ( “ISSUE_NEW” RAW(528) ) ALTER TABLE “ESVALI_TECH”.”TB_TECH_HISTORY_HASU0707″ RENAME TO “TB_TECH_HISTORY_HASU0707_NEW” CREATE OR replace VIEW “ESVALI_TECH”.”TB_TECH_HISTORY_HASU0707_IDV” AS SELECT “INDEX”,        “DATE”,        “CUSTOMER”,        “PRODUCT”,        “VERSION”,        “ISSUE”,        “PROCESS”,        “ETC”,        “ING_ROW_ID” FROM   “ESVALI_TECH”.”TB_TECH_HISTORY_HASU0707_NEW” CREATE OR replace VIEW “ESVALI_TECH”.”TB_TECH_HISTORY_HASU0707″ AS SELECT “INDEX” ,        “DATE” ,        “CUSTOMER” ,        “PRODUCT” ,        “VERSION” ,        “ISSUE” ,        “PROCESS” ,        “ETC” FROM   “ESVALI_TECH”.”TB_TECH_HISTORY_HASU0707_IDV”  CREATE OR replace TRIGGER “ESVALI_TECH”.”TB_TECH_HISTORY_HASU0_INS_TRIG” instead OF  INSERT ON “ESVALI_TECH”.”TB_TECH_HISTORY_HASU0707_IDV” REFERENCING NEW AS NEW OLD AS OLD FOR EACH ROW DECLARE check_22 VARCHAR2         (               512        );BEGIN   SELECT :NEW.”ISSUE”   INTO   check_22   FROM   dual;      INSERT INTO “ESVALI_TECH”.”TB_TECH_HISTORY_HASU0707_NEW”               (                           “INDEX”,                           “DATE”,                           “CUSTOMER”,                           “PRODUCT”,                           “VERSION”, […]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_import_markdown_pro_load_document_selector":0,"_import_markdown_pro_submit_text_textarea":"","site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[10],"tags":[],"class_list":["post-668","post","type-post","status-publish","format-standard","hentry","category-computing_database"],"_links":{"self":[{"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=\/wp\/v2\/posts\/668","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=668"}],"version-history":[{"count":0,"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=\/wp\/v2\/posts\/668\/revisions"}],"wp:attachment":[{"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=668"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=668"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=668"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}