How to create a view in PL/SQL[new]
To Create view in SQL
About View
view is only used to contain select statement.
It does not store the result of select statement
we can perform update ,delete and select operation on view.
The main perpose of view is to secure the select query
from unauthorise excess.
-------------------------------------------------------------------------------------------------
Create a View
create or replace view v1
as select did,dfname from director;