DESCRIBE empvu80 Guidelines The subquery that defines a view can contain complex syntax, including joins, groups, and • SELECT subqueries. If you do not specify a constraint name for the view created with the the system • WITH CHECK OPTION, assigns a default name in the format. SYS_Cn You can use the option to change the definition of the view without dropping and • OR REPLACE it, or regranting the object privileges previously granted on it. VIEW – Examples – with aliases Column aliases CREATE VIEW salvu50 AS SELECT employee_id ID_NUMBER, last_name NAME, salary*12 ANN_SALARY FROM employees WHERE department_id = 50; View – Retrieving Data SELECT * FROM salvu50;
DESCRIBE empvu80 Guidelines • The subquery that defines a view can contain complex SELECT syntax, including joins, groups, and subqueries. • If you do not specify a constraint name for the view created with the WITH CHECK OPTION, the system assigns a default name in the SYS_Cn format. • You can use the OR REPLACE option to change the definition of the view without dropping and it, or regranting the object privileges previously granted on it. VIEW – Examples – with aliases Column aliases CREATE VIEW salvu50 AS SELECT employee_id ID_NUMBER, last_name NAME, salary*12 ANN_SALARY FROM employees WHERE department_id = 50; View – Retrieving Data SELECT * FROM salvu50;