Creating User-defined Functions for Column Objects

   


SQL> -- Creating User-defined Functions for Column Objects
SQL>
SQL> CREATE OR REPLACE TYPE aobj AS object (
  2                    state CHAR(2),
  3                    amt NUMBER(5),
  4
  5                    MEMBER FUNCTION mult (times in number) RETURN number,
  6                    PRAGMA RESTRICT_REFERENCES(mult, WNDS));
  7  /

Type created.

SQL>
SQL> CREATE OR REPLACE TYPE BODY aobj AS
  2    MEMBER FUNCTION mult (times in number) RETURN number
  3    IS
  4    BEGIN
  5      RETURN times * self.amt; /* SEE BELOW */
  6    END;
  7  END;
  8  /

Type body created.

SQL>
SQL> CREATE TABLE aobjtable (arow aobj);

Table created.

SQL>
SQL>
SQL> DESC aobjtable;
 Name                                                                                                  Null?    Type
 ----------------------------------------------------------------------------------------------------- -------- --------------------------------------------------------------------
 AROW                                                                                                   AOBJ

SQL>
SQL> drop table aobjtable;

Table dropped.

SQL>
SQL>

Related examples in the same category

1.	Use method from object in select command
2.	Access member variable in member function in a type
3.	Compare two type object instances
4.	A sample object type with a MAP member function
5.	A sample object type with an ORDER member function.
6.	This script builds a sample object type with member variables and functions
7.	This script demonstrates the static method.
8.	This script demonstrates the order method.
9.	Type with member procedure
10.	Demonstrates the member method.

Creating User-defined Functions for Column Objects : Object Method « Object Oriented Database « Oracle PL / SQL

Related examples in the same category