You can create the following SQL statements as an Other type in DB/Assist.
ALTER TABLE |
Changes the description of a table. |
COMMENT ON |
Replaces or adds a comment to the description of a table, view, or column. |
COMMIT |
Terminates a unit of recovery and commits the database changes made by that unit of recovery. |
CREATE INDEX |
Defines an index on a table. |
CREATE TABLE |
Defines a table |
CREATE VIEW |
Defines a view of one or more tables or views. |
DROP |
Deletes a table, index, package, or view. |
GRANT (Index Privileges) |
Grants the CONTROL privilege on indexes in the database. |
GRANT (Database Privileges) |
Grants privileges on the entire database. |
GRANT (Package Privileges) |
Grants privileges on packages in the database. |
GRANT (Table Privileges) |
Grants privileges on tables and views. |
LOCK TABLE |
Prevents concurrent processes from changing or using a table. |
REVOKE (Index Privileges) |
Revokes the CONTROL privilege on given indexes. |
REVOKE (Database Privileges) |
Revokes privileges from the entire database. |
REVOKE (Package Privileges) |
Revokes privileges from given access plans in the database. |
REVOKE (Table Privileges) |
Revokes privileges from given tables or views. |
ROLLBACK |
Terminates a unit of recovery and backs out the database changes made by that unit of recovery. |
Create an Other type statement by selecting the Other radio button in the New SQL Statement dialog box.
To build an Other type statement after you create it, you can do one of the following:
•Select SQL Statement>Import to import the statement from a file or from the clipboard.
•Type the statement in the SQL Editor window.
