Liquibase script to make all data in a column uppercase Liquibase script to make all data in a column uppercase database database

Liquibase script to make all data in a column uppercase


Try the following changeset:

<changeSet author="mark" id="2013-07-15-01">    <update tableName="MyTable">        <column name="MyColumn" valueComputed="upper(MyColumn)"/>    </update></changeSet>

Documented here.


try this :

 UPDATE  MyTableSET  MyColumn = upper(MyColumn)