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>
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;
No comments:
Post a Comment