DROP TABLE docs
;

CREATE TABLE docs
(
    ID Number primary key, 
    Text varchar2(2000)
)
;

INSERT INTO docs (ID,Text) 
VALUES(1, 'PSP uses syntax similar to that of Active Server Pages (ASP), although the syntax is not identical and you must typically translate from VBScript or JScript to PL/SQL.');

INSERT INTO docs (ID,Text) 
VALUES(2,'The best candidates for migration are pages that use the Active Data Object (ADO) interface to do database operations.');

INSERT INTO docs (ID,Text) 
VALUES(3,'You can start with an existing web page, or with an existing stored procedure.');

Create index docs_index on docs(text) indextype is ctxsys.context;
