Project

General

Profile

1 34 jones
/**
2
 *        Name: xmltest.sql
3
 *     Purpose: create a table for storing test data in oracle
4
 * Institution: National Center for Ecological Analysis and Synthesis
5
 *   Copyright: 2000
6
 *     Authors: Matt Jones
7
 *
8
 *     Version: '$Id$'
9
 */
10
11
CREATE TABLE xmltest (
12
	docid		NUMBER(10) PRIMARY KEY,
13
	lastname	VARCHAR2(25),
14
	firstname	VARCHAR2(25)
15
);