SQL>  create table t1 (id number, name varchar2(20), clob_col clob, blob_col blob);
Table created.
SQL> insert into t1 values (1, 'Donghua', '{"id":1,"first_name":"Iron","last_name":"Man"}', utl_raw.cast_to_raw('Donghua'));
1 row created.
SQL> commit;
Commit complete.
SQL> info t1;
TABLE: T1
         LAST ANALYZED:
         ROWS         :
         SAMPLE SIZE  :
         INMEMORY     :DISABLED
         COMMENTS     :
Columns
NAME         DATA TYPE           NULL  DEFAULT    COMMENTS
 ID          NUMBER              Yes
 NAME        VARCHAR2(20 BYTE)   Yes
 CLOB_COL    CLOB                Yes
 BLOB_COL    BLOB                Yes
SQL> select * from t1;
   ID       NAME                                          CLOB_COL          BLOB_COL
_____ __________ _________________________________________________ _________________
    1 Donghua    {"id":1,"first_name":"Iron","last_name":"Man"}    446F6E67687561
 SQL> lb version
Liquibase version:   4.1.1
Extension Version:   20.4.2.0
SQL> lb data -object t1
Action successfully completed please review created file data1.xml
data1.xml indicates that BLOB_COL is "UNSUPPORTED FOR DIFF: BINARY DATA"
<?xml version="1.1" encoding="UTF-8" standalone="no"?>
<databaseChangeLog xmlns="http://www.liquibase.org/xml/ns/dbchangelog" xmlns:ext="http://www.liquibase.org/xml/ns/dbchangelog-ext" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocati
on="http://www.liquibase.org/xml/ns/dbchangelog-ext http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-ext.xsd http://www.liquibase.org/xml/ns/dbchangelog http://www.liquibase.org/xml/ns/dbchangel
og/dbchangelog-4.1.xsd">
    <changeSet author="oracle (generated)" id="1619509111980-1">
        <insert tableName="T1">
            <column name="ID" valueNumeric="1"/>
            <column name="NAME" value="Donghua"/>
            <column name="CLOB_COL" value="{"id":1,"first_name":"Iron","last_name":"Man"}"/>
            <column name="BLOB_COL" valueComputed="UNSUPPORTED FOR DIFF: BINARY DATA"/>
        </insert>
    </changeSet>
</databaseChangeLog>
 
No comments:
Post a Comment