PriceType becomes the datatype of the price attribute in the ProductType object type : Object « Object Oriented Database « Oracle PL / SQL






PriceType becomes the datatype of the price attribute in the ProductType object type

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

Type created.

SQL>
SQL>
SQL>
SQL> -- Body
SQL>
SQL> CREATE OR REPLACE TYPE BODY PriceType
  2   AS
  3      CONSTRUCTOR FUNCTION PriceType (price NUMBER)
  4         RETURN SELF AS RESULT
  5      AS
  6      BEGIN
  7         SELF.price := price * .9;
  8         RETURN;
  9      END PriceType;
 10   END;
 11   /

Type body created.

SQL>
SQL> show errors
No errors.
SQL>
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.This script demonstrates complex objects
9.Name type
10.Behavior of dependent objects.
11.Build data type with another user type
12.Create the object and collection types
13.Create type and use it in inner query
14.Create types and then use it in pl/sql block
15.Combine user-defined type to create new type
16.Use self to reference member variable in constructor
17.One to list using object references