User view and object id : Create View « View « Oracle PL / SQL






User view and object id

    

SQL> create type addressType as object
  2  (Street  VARCHAR2(50),
  3   City    VARCHAR2(25),
  4   State   CHAR(2),
  5   Zip     NUMBER);
  6  /
SQL> create type personType as object
  2  (Name     VARCHAR2(25),
  3   Address  addressType);
  4  /
SQL>
SQL> create table emp
  2  (cid NUMBER   primary key,
  3   Name        VARCHAR2(25),
  4   Street      VARCHAR2(50),
  5   City        VARCHAR2(25),
  6   State       CHAR(2),
  7   Zip         NUMBER);
SQL>
SQL>
SQL> create or replace type empType as object
  2  (cid NUMBER,
  3   Name        VARCHAR2(25),
  4   Street      VARCHAR2(50),
  5   City        VARCHAR2(25),
  6   State       CHAR(2),
  7   Zip         NUMBER);
  8  /
SQL>
SQL> create view empView of empType
  2  with object OID (cid) as
  3  select cid, Name, Street, City, State, Zip
  4    from emp;
SQL>
SQL>
SQL> drop view empView;
SQL> drop table emp;
SQL>
SQL>
SQL>
SQL> drop type personType;
SQL>
SQL> drop type addressType;
SQL>
SQL>

   
    
    
    
  








Related examples in the same category

1.Create or replace a view
2.Create view without indiating the column name
3.Create OR REPLACE VIEW from selected columns in a table
4.Create a simple view
5.create force view
6.create materialized view
7.Create a view with check option
8.Create view by join three tables
9.Create view on single field of a type
10.Using view to simplify the query
11.Use view based on user-defind type