/** * Name: xmltest.sql * Purpose: create a table for storing test data in oracle * Institution: National Center for Ecological Analysis and Synthesis * Copyright: 2000 * Authors: Matt Jones * * Version: '$Id: xmltest.sql 34 2000-04-13 16:42:03Z jones $' */ CREATE TABLE xmltest ( docid NUMBER(10) PRIMARY KEY, lastname VARCHAR2(25), firstname VARCHAR2(25) );