metacat/xsqltest/xmltest.sql @ 204
1 |
/**
|
---|---|
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: xmltest.sql 34 2000-04-13 16:42:03Z jones $'
|
9 |
*/
|
10 |
|
11 |
CREATE TABLE xmltest ( |
12 |
docid NUMBER(10) PRIMARY KEY, |
13 |
lastname VARCHAR2(25), |
14 |
firstname VARCHAR2(25) |
15 |
);
|