Demonstrates object initialization. : Constructor « Object Oriented Database « Oracle PL / SQL






Demonstrates object initialization.

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

SP2-0816: Type created with compilation warnings

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

SP2-0818: Type Body created with compilation warnings

SQL>
SQL>
SQL> DECLARE
  2     v_price   BookType;
  3  BEGIN
  4     v_price.price := 75;
  5     DBMS_OUTPUT.put_line (v_price.price);
  6  END;
  7  /
75

PL/SQL procedure successfully completed.

   
    
    
    
  








Related examples in the same category

1.Insert value with constructor method
2.Call object constructor in an insert statement
3.Use type Constructor to insert data to object table
4.Use constructor to create new objects
5.This script builds a sample object type with constructor.
6.This script demonstrates the user-defined constructor method.