Advertisement
jacknpoe

Consulta a Programação de Cinema

May 28th, 2016
184
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.38 KB | None | 0 0
  1. DELIMITER |
  2. CREATE OR REPLACE PROCEDURE ConsultarProgramacao( DataConsulta DATE) DETERMINISTIC READS SQL DATA
  3. BEGIN
  4.     SELECT cinema.nome, filme.nome, programacao.horario
  5.     FROM cinema, filme, programacao
  6.     WHERE cinema.codigo = programacao.cinema
  7.       AND filme.codigo = programacao.filme
  8.       AND programacao.data = DataConsulta
  9.     ORDER BY programacao.horario;
  10. END |
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement