This script demonstrates complex objects : Object « Object Oriented Database « Oracle PL / SQL






This script demonstrates complex objects

    

SQL>
SQL>
SQL> CREATE OR REPLACE TYPE PriceType AS OBJECT (
  2     discount_rate  NUMBER(10,4),
  3     price          NUMBER(10,2),
  4
  5     MEMBER FUNCTION discount_price RETURN NUMBER)
  6  INSTANTIABLE
  7  FINAL;
  8  /

Type created.

SQL>
SQL>
SQL> CREATE OR REPLACE TYPE inventory_obj AS OBJECT (
  2     item_id        NUMBER(10),
  3     num_in_stock   NUMBER(10),
  4     reorder_status VARCHAR2(20),
  5     price       REF   PriceType);
  6  /

Type created.

SQL>

   
    
    
    
  








Related examples in the same category

1.Create Object
2.CREATE OR REPLACE TYPE
3.Create a stored type which is visible to SQL and PL/SQL.
4.reference user-defined data type in another block
5.Student type
6.Point type
7.Use user-defined type as parameter
8.Name type
9.Behavior of dependent objects.
10.Build data type with another user type
11.Create the object and collection types
12.Create type and use it in inner query
13.Create types and then use it in pl/sql block
14.Combine user-defined type to create new type
15.PriceType becomes the datatype of the price attribute in the ProductType object type
16.Use self to reference member variable in constructor
17.One to list using object references