mybatis oracle 序列自增与 uuid生成

uuid 利用oracle 自带的函数 或者 自己写序列

<insert id="insertANewUser" parameterType="com.meyacom.fw.um.dto.Use

   
   
	 
    
    
     
     
        select sys_guid() from dual
    
    
    
		INSERT INTO
		T_USER(USER_ID,USER_NAME,EMAIL,LOGIN_PASSWORD, USER_STATUS) values
		(
		#{userId,jdbcType=VARCHAR},
		#{userName,jdbcType=VARCHAR},
		#{email,jdbcType=VARCHAR},
		#{loginPassword,jdbcType=VARCHAR},
		'A')

   
   

   
   
  
    
    
		
    
    
     
       
		       SELECT SEQ_POLICY_ID.nextval as policy_id FROM DUAL
	    
    
     
    insert into T_POLICY (POLICY_ID, POLICY_NUMBER, INSURED, 
      ORG_CODE, COUNT, TELEPHONE, 
      STATUS, UPLOAD)
    values (#{policy_id,jdbcType=DECIMAL}, #{policy_number,jdbcType=VARCHAR}, #{insured,jdbcType=VARCHAR}, 
      #{org_code,jdbcType=VARCHAR}, #{count,jdbcType=DECIMAL}, #{telephone,jdbcType=VARCHAR}, 
      #{status,jdbcType=VARCHAR}, #{upload,jdbcType=VARCHAR})