SQL Syntax

SQL Syntax
ABORT
ALTER AGGREGATE
ALTER AUDIT POLICY
ALTER COLUMN ENCRYPTION KEY
ALTER EVENT
ALTER DATABASE
ALTER DATABASE LINK
ALTER DEFAULT PRIVILEGES
ALTER DIRECTORY
ALTER FOREIGN DATA WRAPPER
ALTER FUNCTION
ALTER GLOBAL CONFIGURATION
ALTER GROUP
ALTER INDEX
ALTER LANGUAGE
ALTER MASKING POLICY
ALTER MATERIALIZED VIEW
ALTER OPERATOR
ALTER PACKAGE
ALTER PROCEDURE
ALTER RESOURCE LABEL
ALTER RESOURCE POOL
ALTER ROLE
ALTER ROW LEVEL SECURITY POLICY
ALTER SCHEMA
ALTER SEQUENCE
ALTER SERVER
ALTER SESSION
ALTER SYNONYM
ALTER SYSTEM KILL SESSION
ALTER TABLE
ALTER TABLE PARTITION
ALTER TABLE SUBPARTITION
ALTER TABLESPACE
ALTER TRIGGER
ALTER TYPE
ALTER USER
ALTER USER MAPPING
ALTER VIEW
ANALYZE | ANALYSE
BEGIN
CALL
CHECKPOINT
CLEAN CONNECTION
CLOSE
CLUSTER
COMMENT
COMMIT | END
COMMIT PREPARED
COPY
CREATE AGGREGATE
CREATE AUDIT POLICY
CREATE CAST
CREATE CLIENT MASTER KEY
CREATE COLUMN ENCRYPTION KEY
CREATE CONVERSION
CREATE DATABASE
CREATE DATABASE LINK
CREATE DIRECTORY
CREATE EVENT
CREATE FOREIGN DATA WRAPPER
CREATE FUNCTION
CREATE GROUP
CREATE INCREMENTAL MATERIALIZED VIEW
CREATE INDEX
CREATE LANGUAGE
CREATE MASKING POLICY
CREATE MATERIALIZED VIEW
CREATE MODEL
CREATE OPERATOR
CREATE OPERATOR CLASS
CREATE PACKAGE
CREATE PROCEDURE
CREATE RESOURCE LABEL
CREATE RESOURCE POOL
CREATE ROLE
CREATE ROW LEVEL SECURITY POLICY
CREATE RULE
CREATE SCHEMA
CREATE SEQUENCE
CREATE SERVER
CREATE SYNONYM
CREATE TABLE
CREATE TABLE AS
CREATE TABLE PARTITION
CREATE TABLESPACE
CREATE TABLE SUBPARTITION
CREATE TRIGGER
CREATE TYPE
CREATE USER
CREATE USER MAPPING
CREATE VIEW
CREATE WEAK PASSWORD DICTIONARY
CURSOR
DEALLOCATE
DECLARE
DELETE
DO
DROP AGGREGATE
DROP AUDIT POLICY
DROP CAST
DROP CLIENT MASTER KEY
DROP COLUMN ENCRYPTION KEY
DROP DATABASE
DROP DATABASE LINK
DROP DIRECTORY
DROP EVENT
DROP FOREIGN DATA WRAPPER
DROP FUNCTION
DROP GLOBAL CONFIGURATION
DROP GROUP
DROP INDEX
DROP LANGUAGE
DROP MASKING POLICY
DROP MATERIALIZED VIEW
DROP MODEL
DROP OPERATOR
DROP OWNED
DROP PACKAGE
DROP PROCEDURE
DROP RESOURCE LABEL
DROP RESOURCE POOL
DROP ROLE
DROP ROW LEVEL SECURITY POLICY
DROP RULE
DROP SCHEMA
DROP SEQUENCE
DROP SERVER
DROP SYNONYM
DROP TABLE
DROP TABLESPACE
DROP TRIGGER
DROP TYPE
DROP USER
DROP USER MAPPING
DROP VIEW
DROP WEAK PASSWORD DICTIONARY
EXECUTE
EXPDP DATABASE
EXPDP TABLE
EXPLAIN
EXPLAIN PLAN
FETCH
GRANT
IMPDP DATABASE CREATE
IMPDP RECOVER
IMPDP TABLE
IMPDP TABLE PREPARE
INSERT
LOCK
MERGE INTO
MOVE
PREDICT BY
PREPARE
PREPARE TRANSACTION
PURGE
REASSIGN OWNED
REFRESH INCREMENTAL MATERIALIZED VIEW
REFRESH MATERIALIZED VIEW
REINDEX
RELEASE SAVEPOINT
RESET
REVOKE
ROLLBACK
ROLLBACK PREPARED
ROLLBACK TO SAVEPOINT
SAVEPOINT
SELECT
SELECT INTO
SET
SET CONSTRAINTS
SET ROLE
SET SESSION AUTHORIZATION
SET TRANSACTION
SHOW
SHOW EVENTS
SHUTDOWN
SNAPSHOT
START TRANSACTION
TIMECAPSULE TABLE
TRUNCATE
UPDATE
VACUUM
VALUES
ALTER EXTENSION
CREATE EXTENSION
DROP EXTENSION

Parent topic: SQL Reference

Previous topic: DCL Syntax Overview

Next topic: SQL Syntax

Feedback

Was this page helpful?

Helpful Not helpful

Provide feedback

Thank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.

The system is busy. Please try again later.

Which of the following issues have you encountered?

Content is inconsistent with the product UI

Unclear descriptions

Lack of examples or code

Incorrect steps

Can't find what I need

Lack of best practices

Feedback (optional)

0/500

Select at least one type of issue, and enter your comments or suggestions.

Enter a maximum of 500 characters.

Submit Cancel

For any further questions, feel free to contact us through the chatbot.

Chatbot