Populate the table with text search data

This example populates the CLOB column of the reports table with data from the operating system file /local0/excal/dbms.txt by using the FileToCLOB() smart large object function.

INSERT INTO reports (doc_no, author, title, abstract)
    VALUES( 
        1, 
        'C.J. Date',
        'Introduction to Database Systems',
        FileToCLOB ('/local0/excal/dbms.txt', 'client')
);