Oracle Text Reference Release 9.0.1 Part Number A90121-01 |
|
Loading Examples, 2 of 4
A simple way to populate a text table is to create a table with two columns, id
and text
, using CREATE TABLE and then use the INSERT statement to load the data. This example makes the id
column the primary key, which is optional. The text
column is VARCHAR2:
create table docs (id number primary key, text varchar2(80));
To populate the text
column, use the INSERT statement as follows:
insert into docs values(1, 'this is the text of the first document'); insert into docs values(12, 'this is the text of the second document');
|
Copyright © 1996-2001, Oracle Corporation. All Rights Reserved. |
|