ITDA1001 [Lesson 11] Copyright © 2018 VIT, All Rights Reserved 1
Copyright © 2015 – 2018, Victorian Institute of Technology.
The contents contained in this document may not be reproduced in any form or by any means, without the written permission of VIT,
other than for the purpose for which it has been supplied. VIT and its logo are trademarks of Victorian Institute of Technology.
SQL VIEWS (Cont…)
ITDA1001 [Lesson 11] Copyright © 2018 VIT, All Rights Reserved 2
Topics
• Ease of Application Development
• Processing User Views
• Updating & Inserting User View
• Insert / Update / Delete Views
ITDA1001 [Lesson 11] Copyright © 2018 VIT, All Rights Reserved 3
Ease of Application Development
• Simplification of Routine Statements:
Base Tables: Movies, IssueTran and Customers
Views created are as follows:
– CREATE VIEW TwoDollarColumbiaMovies AS
SELECT * FROM Movies
WHERE Producer = ‘Columbia’
The post Ease of Application Development appeared first on Assignment Freelancers.