INF4211

Bases de données pour les organisations

Project maintained by guyfrancoeur Hosted on GitHub Pages — Theme by mattgraham

Les Views

-- Les Views
DROP VIEW V1;
CREATE OR REPLACE VIEW V1 AS
  SELECT course_id FROM course WHERE course_id NOT IN (
    SELECT course_id 
    FROM course
    WHERE dept_name='Biology' OR dept_name ='Finance'
  );

--
SELECT * FROM v1;

INSERT INTO Course (Course_id) VALUES ('CS-999');
INSERT INTO Course (Course_id) VALUES ('CS-998');

--Insertion par les vues
INSERT INTO V1 (Course_id) VALUES ('ZZ-999');

-- Selection utilisant une vue
SELECT * FROM V1, takes
WHERE V1.course_id = takes.course_id;