View is a syntax or script of query oracle syntax stored in database.
Basic syntax is :
CREATE or REPLACE VIEW view_name AS select column1,column2,... from table_name;
example :
CREATE or REPLACE VIEW v_customer AS select id_custmer,name from customer;
Subscribe to:
Posts (Atom)