Oracle8i Application Developer's Guide - XML Release 3 (8.1.7) Part Number A86030-01 |
|
Customizing Content with XML: Dynamic News Application, 5 of 16
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. |
|