Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- insert into seguridad.ROL_USUARIO(id,ID_USUARIO,ID_ROL);
- select rownum+48,w.*
- from (
- select u.ID usr,r.ID rrol
- from seguridad.usuario u
- cross join seguridad.rol r
- minus
- select rr.ID_USUARIO,rr.ID_ROL
- from seguridad.ROL_USUARIO rr ) w
- ;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement