SQL Language (MOSC)

MOSC Banner

SQL output differs between 11G and 12c

in SQL Language (MOSC) 10 commentsAnswered

SQL output differs between 11G and 12c. In 11G the update statement updates the records with values whereas in 12c version the update of the filed value is with NULL.


UPDATE table_name1 bwd

      SET (bwd.column1) =

          (SELECT bdc.column1

             FROM table_name2         bwi,

                  table_name3      bwo,

                  table_name4 bdc

            WHERE bwi.column2 = bwd.column2

              AND bwi.column3 = bwo.column3

              AND (bwi.column4 = bdc.column2 OR bwi.column5 = bdc.column3)

              AND bwo.column5 = bdc.column5

              AND substr(bwi.column6, 1, 8) =

                  substr(bdc.column6, 1, 8)

           ),

          column7 = 1,

          column8 = 1,

          column9 = 1,

          column10 = -1

    WHERE bwd.column3 = 202011263543642;


Please help me to understand the difference.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center