Get primary KEY (Oracle trigger vs. seq) when Mybatis insert operation

1. Through the Oracle sequence

1. --Create sequence
2. Create sequence Seq_dw_ewsystem
   
3. MinValue 1
4. MaxValue 999999999999999999999999999
5. Start with 1
6. Increment by 1
7. Cache 20;

2. <insert id="Insertewsystem" parametertype="Ewsystem">
4. <selectkey keyproperty="id" resulttype="Long" order="before">
6. SELECT Seq_ewsystem. Nextval from DUAL <!--SELECT DECODE (MAX (ID), Null,0,max (ID)) +1 from Ewsystem--
8. </selectkey>
10. INSERT into Ewsystem (id,org_id,name) VALUES (#{id},#{orgid,jdbctype=varchar},#{name,jdbctype= VARCHAR})
12. </Insert>

2. Through Oracle triggers

1. create or  replace trigger trg_dw_ewsystem  
2.  before insert 
3. on dw_ewsystem  FOR&NBSP;EACH&NBSP;ROW&NBSP;
4. begin  
5. Select seq_dw_ewsystem.nextval into :new.id  from dual; 
6. end; 

2. <insert id="Insertewsystem" parametertype="Ewsystem">
4. <selectkey resulttype="int" keyproperty="id" order="after">
6. SELECT seq_dw_Ewsystem. Currval from DUAL
8. </selectkey>
10. INSERT into Ewsystem (id,org_id,name) VALUES (#{id},#{orgid,jdbctype=varchar},#{name,jdbctype= VARCHAR})
12. </Insert>

Get primary KEY (Oracle trigger vs. seq) when Mybatis insert operation