Creating the Text Table

Perform the following steps to create and load documents into a table.

  1. Connect as the new user.

    Before creating any tables, assume the identity of the user that you created.

    CONNECT myuser;

  2. Create your text table.

    The following example creates a table called docs with two columns, id and text, by using the CREATE TABLE statement. This example makes the id column the primary key. The text column is VARCHAR2.

    CREATE TABLE docs (id NUMBER PRIMARY KEY, text VARCHAR2(200));

Note: Primary keys of the following type are supported: NUMBER, VARCHAR2, DATE, CHAR, VARCHAR, and RAW.

  1. Load documents into the table.

    Use the SQL INSERT statement to load text into a table.

    To populate the docs table, use the INSERT statement:

    INSERT INTO docs VALUES(1, '<HTML>California is a state in the US.</HTML>'); INSERT INTO docs VALUES(2, '<HTML>Paris is a city in France.</HTML>'); INSERT INTO docs VALUES(3, '<HTML>France is in Europe.</HTML>');