• Home
• org.liquibase
• liquibase-test-harness
• 1.0.5
• source code
• addNotNullConstraintBitBoolean.sql

×

Project download

Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $

You can buy this project and download/modify it how often you want.

liquibase.harness.change.expectedSql.oracle.18.3.0.addNotNullConstraintBitBoolean.sql Maven / Gradle / Ivy

CREATE TABLE DATICAL_ADMIN.test_table (id INTEGER, bit_col NUMBER(1), boolean_col NUMBER(1))
INSERT INTO DATICAL_ADMIN.test_table (id) VALUES (1)
UPDATE DATICAL_ADMIN.test_table SET bit_col = 1 WHERE bit_col IS NULL
ALTER TABLE DATICAL_ADMIN.test_table MODIFY bit_col NOT NULL
UPDATE DATICAL_ADMIN.test_table SET boolean_col = 1 WHERE boolean_col IS NULL
ALTER TABLE DATICAL_ADMIN.test_table MODIFY boolean_col NOT NULL