ora-00933 – Tarik Billa

how to modify an existing check constraint?

January 26, 2023 by Tarik

You have to drop it and recreate it, but you don’t have to incur the cost of revalidating the data if you don’t want to. alter table t drop constraint ck ; alter table t add constraint ck check (n < 0) enable novalidate; The enable novalidate clause will force inserts or updates to have … Read more

Update statement with inner join on Oracle

September 25, 2022 by Tarik

That syntax isn’t valid in Oracle. You can do this: UPDATE table1 SET table1.value = (SELECT table2.CODE FROM table2 WHERE table1.value = table2.DESC) WHERE table1.UPDATETYPE=’blah’ AND EXISTS (SELECT table2.CODE FROM table2 WHERE table1.value = table2.DESC); Or you might be able to do this: UPDATE (SELECT table1.value as OLD, table2.CODE as NEW FROM table1 INNER JOIN … Read more