Search This Blog

Sunday, May 26, 2019

Multi Table Update In One Update Query

UPDATE (SELECT B.CHECK_V AS OLD, B.CHECK_V AS NEW

          FROM MAS A INNER JOIN DTL B ON A.ID = B.SECTION_ID

         WHERE A.DOCNUMBR = :P6_DOC AND B.ROWID = :ROWID_X) T

   SET T.NEW = :CHECK_V;
<title>
<span style="font-family: "courier new" , "courier" , monospace;">UPDATE (SELECT B.CHECK_V AS OLD, B.CHECK_V AS NEW</span><br />
<span style="font-family: "courier new" , "courier" , monospace;">          FROM MAS A INNER JOIN DTL B ON A.ID = B.SECTION_ID</span><br />
<span style="font-family: "courier new" , "courier" , monospace;">         WHERE A.DOCNUMBR = :P6_DOC AND B.ROWID = :ROWID_X) T</span><br />
<span style="font-family: "courier new" , "courier" , monospace;">   SET T.NEW = :CHECK_V;</span>
UPDATE (SELECT B.CHECK_V AS OLD, B.CHECK_V AS NEW FROM MAS A INNER JOIN DTL B ON A.ID = B.SECTION_ID WHERE A.DOCNUMBR = :P6_DOC AND B.ROWID = :ROWID_X) T SET T.NEW = :CHECK_V; <title> <span style="font-family: "courier new" , "courier" , monospace;">UPDATE (SELECT B.CHECK_V AS OLD, B.CHECK_V AS NEW</span><br /> <span style="font-family: "courier new" , "courier" , monospace;">          FROM MAS A INNER JOIN DTL B ON A.ID = B.SECTION_ID</span><br /> <span style="font-family: "courier new" , "courier" , monospace;">         WHERE A.DOCNUMBR = :P6_DOC AND B.ROWID = :ROWID_X) T</span><br /> <span style="font-family: "courier new" , "courier" , monospace;">   SET T.NEW = :CHECK_V;</span>

No comments:

Post a Comment

Search String Inside Oracle Database Objects SQL

SELECT owner, name, type, line, text  FROM dba_source WHERE instr(UPPER(text), UPPER('string')) > 0;