Sams Teach Yourself SQL in 21 Days, Fourth Edition

Creating Views on Your Tables

If you want to create views on a group of tables, you could try something similar to the following example:

SQL> SET ECHO OFF
SQL> SET FEEDBACK OFF
SQL> SET HEADING OFF
SQL> SPOOL VIEWS.SQL
SQL> SELECT 'CREATE VIEW ' || TABLE_NAME || '_VIEW AS SELECT * FROM ' ||
  2         TABLE_NAME || ';'
  3  FROM CAT
  4  / CREATE VIEW ACCT_PAY_VIEW AS SELECT * FROM ACCT_PAY; CREATE VIEW ACCT_REC_VIEW AS SELECT * FROM ACCT_REC; CREATE VIEW CUSTOMERS_VIEW AS SELECT * FROM CUSTOMERS; CREATE VIEW EMPLOYEES_VIEW AS SELECT * FROM EMPLOYEES; CREATE VIEW HISTORY_VIEW AS SELECT * FROM HISTORY; CREATE VIEW INVOICES_VIEW AS SELECT * FROM INVOICES; CREATE VIEW ORDERS_VIEW AS SELECT * FROM ORDERS; CREATE VIEW PRODUCTS_VIEW AS SELECT * FROM PRODUCTS; CREATE ...