Oracle8i Application Developer's Guide - XML Release 3 (8.1.7) Part Number A86030-01 |
Library | Service | Contents | Index

Customizing Content with XML: Dynamic News Application, 5 of 16

## Dynamic News SQL Example 1: Item Schema, nisetup.sql

Here's the SQL from nisetup.sql, that defines the structure of a news item:

    CREATE TABLE news.NEWS_ITEMS
    ( ID   NUMBER NOT NULL,
      TITLE           VARCHAR2(200),
      URL             VARCHAR2(200),
      DESCRIPTION     VARCHAR2(2000),
      ENTRY_DATE      DATE,
      CATEGORY_ID     NUMBER,
      SUB_CATEGORY_ID NUMBER,
      TYPE_ID         NUMBER,
      SUBMITTED_BY_ID NUMBER,
      EXPIRATION_DATE DATE,  A
      APPROVED_FLAG   VARCHAR2(1)
    );

| Copyright © 1996-2000, Oracle Corporation. All Rights Reserved. |
Library | Service | Contents | Index