SQL_OPTS = statement-type [, statement-type, ...];
where statement-type is one of the following types:
CREATE | (CREATE TABLE and CREATE VIEW commands) |
INSERT | (INSERT INTO commands) |
INDEX | (CREATE INDEX commands) |
SYNONYM | (CREATE SYNONYM commands) |
CHECK | (ALTER TABLE...CHECK commands) |
COMMENT | (COMMENT ON commands) |
For example:
SQL_OPTS = CREATE, INDEX;
selects CREATE TABLE, CREATE VIEW, and CREATE INDEX SQL commands for use in the target file.