Description

Virtual Private Database by Views

Thislab requires you to use Oracle VIEW to implement a virtual database onDBSEC schema, for example, on CUSTOMER table. Your task is to develop asingle SQL script that will perform all the following tasks:

  • Connect to DBSEC/ IS481%sec, the same user you created in previous projects.
  • Create a CUSTOMER table with the following columns:

Column Name

Data Type

SALES_REP_ID

NUMBER(4)