Create View In Dbms Explain With Examples

Create View In Dbms Explain With Examples, How To Create View In DBMS 

How To Create View

Create view view-name AS
SELECT column-name, column-name
FROM table-name
WHERE column_name =expression list;

Examples:

Create view v_emp AS
Select   fname, lname,SSN, Bdate, address,dno, supSSN  from employee;

Create view v_emp AS
Select   *  from employee;

Tweet