Oracle生产固定GUID同时生成随机的GUID

select sys_guid() id,
 t2.INTERNAL_ID, 
 t3.gmsfhm, 
 t2.hhnbid
  from gzk_gongan_czrkjbxxb t3
  join (select (select sys_guid() from dual) INTERNAL_ID, t1.hhnbid hhnbid
          from gzk_gongan_czrkjbxxb t1
         where t1.yhzgx in ('01', '02')
           and t1.gmsfhm = '342623198704293424'
           and t1.ryzt = '0'
           and t1.jlbz = '1'
           and t1.hb = '6') t2
    on t3.hhnbid = t2.hhnbid