<database-object>
        <create>
            <![CDATA[CREATE OR REPLACE TRIGGER t_i_my_entity
            BEFORE INSERT ON my_entity
            FOR EACH ROW
            BEGIN
                select nvl( max(id), 0 ) + 1
                into :new.id
                from my_entity;
            END;]]>
        </create>
        <drop>
            <![CDATA[DROP TRIGGER t_i_my_entity]]>
        </drop>
        <dialect-scope name="org.hibernate.dialect.Oracle9iDialect"/>
        <dialect-scope name="org.hibernate.dialect.Oracle10gDialect"/>
    </database-object>