Advertisement
Guest User

Untitled

a guest
Aug 25th, 2016
55
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.24 KB | None | 0 0
  1. insert into seguridad.ROL_USUARIO(id,ID_USUARIO,ID_ROL);
  2. select rownum+48,w.*
  3. from (
  4. select u.ID usr,r.ID rrol
  5. from seguridad.usuario u
  6. cross join seguridad.rol r
  7. minus
  8. select rr.ID_USUARIO,rr.ID_ROL
  9. from seguridad.ROL_USUARIO rr ) w
  10. ;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement