Saturday 23 July 2016

Views (virtual Tables) in SQL



Views (virtual Tables) in SQL: The SQL DDL includes commands for defining views.A views is customized presentation of the data from one or more tables. views derive their data from the tables on which they are based, which are known as base ables of the view.


Non procedural Language :SQL is a non procedural language because it:


·         Processess sets of records rather than just one at a time

·         provides automatics navigation to the data

·        system administrators

·         Database administrators

·         Securiuty administrators

·         Application programmers

 



No comments:

Post a Comment