Statements that the Run option supports

After you exit the editor screen, the SQL menu reopens with the Run option highlighted and the statement text is displayed in the bottom of the screen. You can run most SQL statements with the Run option.

To run statements that are not listed, use the SQL menu options New (or Use-editor) and Save to enter and save them, and then run the saved file from the command line.

The following is a list of SQL statements that you can run with the Run option.
  • ALLOCATE COLLECTION
  • ALLOCATE DESCRIPTOR
  • ALLOCATE ROW
  • ALTER ACCESS_METHOD
  • ALTER FRAGMENT
  • ALTER FUNCTION
  • ALTER INDEX
  • ALTER PROCEDURE
  • ALTER ROUTINE
  • ALTER SECURITY LABEL COMPONENT
  • ALTER SEQUENCE
  • ALTER TABLE
  • BEGIN WORK
  • CLOSE
  • CLOSE DATABASE
  • COMMIT WORK
  • CONNECT
  • CREATE ACCESS_METHOD
  • CREATE AGGREGATE
  • CREATE CAST
  • CREATE DATABASE
  • CREATE DISTINCT TYPE
  • CREATE EXTERNAL TABLE
  • CREATE FUNCTION
  • CREATE FUNCTION FROM
  • CREATE INDEX
  • CREATE OPAQUE TYPE
  • CREATE OPCLASS
  • CREATE PROCEDURE
  • CREATE ROLE
  • CREATE ROUTINE FROM
  • CREATE ROW TYPE
  • CREATE SCHEMA
  • CREATE SECURITY LABEL COMPONENT
  • CREATE SECURITY LABEL
  • CREATE SECURITY POLICY
  • CREATE SEQUENCE
  • CREATE SYNONYM
  • CREATE TABLE
  • CREATE TRIGGER
  • CREATE VIEW
  • CREATE XADATASOURCE
  • CREATE XADATASOURCE TYPE
  • DATABASE
  • DEALLOCATE COLLECTION
  • DEALLOCATE DESCRIPTOR
  • DEALLOCATE ROW
  • DECLARE
  • DELETE
  • DESCRIBE
  • DESCRIBE INPUT
  • DISCONNECT
  • DROP ACCESS METHOD
  • DROP AGGREGATE
  • DROP CAST
  • DROP DATABASE
  • DROP FUNCTION
  • DROP INDEX
  • DROP OPAQUE TYPE
  • DROP OPCLASS
  • DROP PROCEDURE
  • DROP ROLE
  • DROP ROW TYPE
  • DROP SECURITY LABEL COMPONENT/POLICY/LABEL
  • DROP SEQUENCE
  • DROP SYNONYM
  • DROP TABLE
  • DROP TRIGGER
  • DROP TYPE
  • DROP VIEW
  • DROP XADATASOURCE
  • DROP XADATASOURCE TYPE
  • EXECUTE
  • EXECUTE FUNCTION
  • EXECUTE IMMEDIATE
  • EXECUTE PROCEDURE
  • FETCH
  • FLUSH
  • FREE
  • GET DESCRIPTOR
  • GET DIAGNOSTICS
  • GRANT
  • GRANT DBSECADM
  • GRANT DEFAULT ROLE
  • GRANT EXEMPTION
  • GRANT FRAGMENT
  • GRANT SECURITY LABEL
  • INFO
  • INSERT
  • LOAD
  • LOCK TABLE
  • MERGE
  • OPEN
  • OUTPUT
  • PREPARE
  • PUT
  • RENAME COLUMN
  • RENAME DATABASE
  • RENAME INDEX
  • RENAME SEQUENCE
  • RENAME TABLE
  • REVOKE
  • REVOKE DBSECADM
  • REVOKE DEFAULT ROLE
  • REVOKE EXEMPTION
  • REVOKE FRAGMENT
  • REVOKE SECURITY LABEL
  • ROLLBACK WORK
  • SAVE EXTERNAL DIRECTIVES
  • SELECT
  • SET AUTOFREE
  • SET COLLATION
  • SET CONNECTION
  • SET CONSTRAINTS
  • SET DATASKIP
  • SET DEBUG FILE TO
  • SET DEFERRED PREPARE
  • SET DESCRIPTOR
  • SET ENCRYPTION PASSWORD
  • SET ENVIRONMENT
  • SET EXPLAIN
  • SET ISOLATION
  • SET LOCK MODE
  • SET LOG
  • SET OPTIMIZATION
  • SET PDQPRIORITY
  • SET ROLE
  • SET SESSION AUTHORIZATION
  • SET STATEMENT CACHE
  • SET TRANSACTION
  • START VIOLATIONS TABLE
  • STOP VIOLATIONS TABLE
  • TRUNCATE
  • UNLOAD
  • UNLOCK TABLE
  • UPDATE
  • UPDATE STATISTICS
  • WHENEVER