SQL命令列表

本节按字母序给出了神通数据库中支持的所有SQL命令的详细说明，包括各命令的功能说明、语法说明、语法图例、参数说明、注释信息和使用举例。为帮助用户更好地理解各SQL命令用法，首先在6.6.1节给出了SQL语法图的介绍。

• 如何阅读SQL语法图
• ABORT
• ALTER DATABASE
• ALTER DATABASELINK
• ALTER FULLTEXT INDEX
• ALTER INDEX
• ALTER MASKING POLICY
• ALTER MULTIPLE STATISTICS
• ALTER OUTLINE
• ALTER RESOURCE LABEL
• ALTER ROLE
• ALTER ROLLBACK SEGMENT
• ALTER SCHEMA
• ALTER SEQUENCE
• ALTER STATISTICS
• ALTER SYSTEM
• ALTER TABLE
• ALTER TABLESPACE
• ALTER TRIGGER
• ALTER USER
• ALTER VIEW
• ANALYZE
• AUDIT
• BEGIN
• BULK INSERT
• CALL
• CLEAN AUDIT CONFIGURATION
• CLEAN ROLLBACK SEGMENT
• CLOSE
• COMMENT ON
• COMMIT
• CREATE COLUMN ENCRYPTION KEY
• CREATE COLUMN MASTER KEY
• CREATE CONTEXT
• CREATE DATABASE
• CREATE DATABASELINK
• CREATE DIRECTORY
• CREATE DOMAIN
• CREATE EXTERNAL TABLE
• CREATE FULLTEXT INDEX
• CREATE FUNCTION
• CREATE INDEX
• CREATE MASKING POLICY
• CREATE MATERIALIZED VIEW
• CREATE MATERIALIZED VIEW LOG
• CREATE MULTIPLE STATISTICS
• CREATE OUTLINE
• CREATE PROCEDURE
• CREATE RESOURCE LABEL
• CREATE ROLE
• CREATE ROLLBACK SEGMENT
• CREATE SCHEMA
• CREATE SEQUENCE
• CREATE STATISTICS
• CREATE SYNONYM
• CREATE TABLE
• CREATE TABLE AS
• CREATE TABLESPACE
• CREATE TRIGGER
• CREATE USER
• CREATE VIEW
• DEALLOCATE
• DEALLOCATE PREPARE
• DECLARE
• DELETE
• DROP AUDIT
• DROP COLUMN ENCRYPTION KEY
• DROP COLUMN MASTER KEY
• DROP CONTEXT
• DROP DATABASE
• DROP DATABASELINK
• DROP DIRECTORY
• DROP DOMAIN
• DROP FULLTEXT INDEX
• DROP FUNCTION
• DROP INDEX
• DROP MASKING POLICY
• DROP MATERIALIZED VIEW
• DROP MATERIALIZED VIEW LOG
• DROP MULTIPLE STATISTICS
• DROP OUTLINE
• DROP PROCEDURE
• DROP RESOURCE LABEL
• DROP ROLE
• DROP ROLLBACK SEGMENT
• DROP SAVEPOINT
• DROP SCHEMA
• DROP SEQUENCE
• DROP STATISTICS
• DROP SYNONYM
• DROP TABLE
• DROP TABLESPACE
• DROP TRIGGER
• DROP USER
• DROP VIEW
• END
• EXEC
• EXECUTE
• EXPLAIN
• FETCH
• FLASHBACK TABLE
• GET DESCRIPTION OF
• GET PARAMINFO FOR
• GET ROWDESCRIPTION FOR
• GRANT
• INSERT
• KILL
• LOCK TABLE
• MERGE
• MOVE
• NOAUDIT
• OPEN
• OPTIMIZE FULLTEXT INDEX
• PREPARE
• PURGE
• REFRESH MATERIALIZED VIEW
• REPLACE
• RESET
• REVOKE
• ROLLBACK
• SAVEPOINT
• SELECT
• SELECT: FLASHBACK
• SELECT: FOR UPDATE
• SELECT: FROM
• SELECT: GROUP BY
• SELECT: HAVING
• SELECT: INTO
• SELECT: LIMIT
• SELECT: ORDER BY
• SELECT: PIVOT
• SELECT: SETOP
• SELECT: TOP PERCENT
• SELECT: UNPIVOT
• SELECT: WHERE
• SET
• SET AUTOCOMMIT
• SET TRANSACTION
• SHOW
• SHUTDOWN
• START AUDIT
• START TRANSACTION
• TRUNCATE
• UPDATE
• UPDATE MULTIPLE STATISTICS
• UPDATE STATISTICS
• WITH AS
• WITH FUNCTION