Create view on single field of a type : Create View « View « Oracle PL / SQL






Create view on single field of a type

   


SQL> create type addressType as object
  2  (Street   VARCHAR2(50),
  3  City      VARCHAR2(25),
  4  State     CHAR(2),
  5  Zip       NUMBER);
  6  /
SQL>
SQL> create type personType as object
  2  (Name     VARCHAR2(25),
  3   Address  addressType);
  4  /
SQL>
SQL>
SQL> create or replace type personType as object
  2  (Name     VARCHAR2(25),
  3   Address  addressType);
  4  /
SQL>
SQL>
SQL> create table myemp
  2  (cid    NUMBER,
  3   Person         personType);
SQL>
SQL>
SQL> insert into myemp values(1,personType('SomeName',addressType('StreetValue','CityValue','ST',11111)));
SQL>
SQL>
SQL> create index empview
  2  on myemp(Person.Address.City);
SQL>
SQL>
SQL> drop table myemp;
SQL> drop type personType;
SQL> drop type addressType;
SQL>
SQL>
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.Using view to simplify the query
10.User view and object id
11.Use view based on user-defind type