Difference between revisions of "OE.CATALOG TYP (type)"

From dbscript Online Help
Jump to: navigation, search
Line 3: Line 3:
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
|-
 
|-
| '''type
+
| '''Type
 
| OE.CATALOG_TYP
 
| OE.CATALOG_TYP
 
|-
 
|-
Line 9: Line 9:
  
  
 +
=== Source ===
 
<pre>
 
<pre>
 
CREATE OR REPLACE TYPE catalog_typ
 
CREATE OR REPLACE TYPE catalog_typ

Revision as of 09:27, 11 February 2010

wikibot

Type OE.CATALOG_TYP


Source

CREATE OR REPLACE TYPE catalog_typ
                                         UNDER composite_category_typ
      (
    MEMBER FUNCTION getCatalogName RETURN VARCHAR2
       , OVERRIDING MEMBER FUNCTION category_describe RETURN VARCHAR2
      );TYPE BODY catalog_typ AS
  OVERRIDING MEMBER FUNCTION category_describe RETURN varchar2 IS
  BEGIN
    RETURN 'catalog_typ';
  END;
  MEMBER FUNCTION getCatalogName RETURN varchar2 IS
  BEGIN
    -- Return the category name from the supertype
    RETURN self.category_name;
  END;
END;