Welcome Guest, you are in: Login

devio dbscript ScrewTurn Wiki

RSS RSS

Navigation





Search the wiki
»

PoweredBy

OE CATEGORY_TYP (type)

RSS
Modified on 2011/08/27 12:10 by wikibot Categorized as Uncategorized

wikibot

TypeOE.CATEGORY_TYP

Source

CREATE OR REPLACE TYPE category_typ
                                         AS OBJECT
    ( category_name           VARCHAR2(50)
    , category_description    VARCHAR2(1000)
    , category_id             NUMBER(2)
    , NOT instantiable
      MEMBER FUNCTION category_describe RETURN VARCHAR2
      )
  NOT INSTANTIABLE NOT FINAL
 ALTER TYPE category_typ
 ADD ATTRIBUTE (parent_category_id number(2)) CASCADE

ScrewTurn Wiki version 3.0.1.400. Some of the icons created by FamFamFam.