Used to specify which SQL statements should be generated when the SQL export type is chosen. The syntax is:
SQL_OPTS = statement-type [, statement-type, ...];
where statement-type is one of the types shown in the table below.
| Statement type | SQL Statement |
|---|---|
| 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.