Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT my_mv_capabilities( 'select u.nomeusuario, l.nomelivro, a.nomeautor, e.dataemprestimo, e.datadevolucao
- from usuario u join emprestimo e
- on (u.codusuario = e.codusuario) join livro l
- on (e.codlivro = l.codlivro) join autor a
- on(l.codautor = a.codautor)', 'REFRESH' ) AS mv_report FROM dual ;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement