在oracle中将BLOB数据更改为CLOB的Liquibase脚本

<databaseChangeLog xmlns="http://www.liquibase.org/xml/ns/dbchangelog"
                   xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
                   xsi:schemaLocation="http://www.liquibase.org/xml/ns/dbchangelog
                                       http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-3.8.xsd">

    <changeSet id="change-blob-to-clob" author="your-name">
        <preConditions onFail="MARK_RAN">
            <columnExists tableName="your-table" columnName="your-blob-column"/>
        </preConditions>
        <addColumn tableName="your-table">
            <column name="temp_clob" type="clob"/>
        </addColumn>
        <update tableName="your-table">
            <column name="temp_clob" valueComputed="TO_CLOB(your-blob-column)"/>
        </update>
        <dropColumn tableName="your-table" columnName="your-blob-column"/>
        <renameColumn tableName="your-table" oldColumnName="temp_clob" newColumnName="your-clob-column"/>
    </changeSet>

</databaseChangeLog>