Welcome Guest, you are in: <root> • Login

Page History: OE CATEGORY_TYP (type)

Compare Page Revisions

1 0 Current 1 0

« Older Revision - Back to Page History - Newer Revision »

Page Revision: 2010/02/11 09:18

wikibot ¶

Type	OE.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