what is the difference between view and select statement?
A view can be described as a virtual table, created from a SQL query stored in the database. ... Once the view is created, your application developers will have to deal with the SELECT statements using column in the same view, hence the term virtual table. Security: or just called it access control.