SQL Syntax

Updated on 2024-05-07 GMT+08:00

View PDF

SQL Syntax
ABORT
ALTER AUDIT POLICY
ALTER COLUMN ENCRYPTION KEY
ALTER COORDINATOR
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 NODE
ALTER NODE GROUP
ALTER RESOURCE LABEL
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 TABLESPACE
ALTER TRIGGER
ALTER TYPE
ALTER USER
ALTER VIEW
ANALYZE | ANALYSE
BEGIN
CALL
CHECKPOINT
CLEAN CONNECTION
CLOSE
CLUSTER
COMMENT
COMMIT | END
COMMIT PREPARED
COPY
CREATE AUDIT POLICY
CREATE BARRIER
CREATE CLIENT MASTER KEY
CREATE COLUMN ENCRYPTION KEY
CREATE CONVERSION
CREATE DATABASE
CREATE DATABASE LINK
CREATE DIRECTORY
CREATE FOREIGN DATA WRAPPER
CREATE FUNCTION
CREATE GLOBAL INDEX
CREATE GROUP
CREATE INCREMENTAL MATERIALIZED VIEW
CREATE INDEX
CREATE LANGUAGE
CREATE MASKING POLICY
CREATE MATERIALIZED VIEW
CREATE MODEL
CREATE NODE
CREATE NODE GROUP
CREATE PROCEDURE
CREATE RESOURCE LABEL
CREATE ROLE
CREATE ROW LEVEL SECURITY POLICY
CREATE SCHEMA
CREATE SEQUENCE
CREATE SERVER
CREATE SYNONYM
CREATE TABLE
CREATE TABLESPACE
CREATE TABLE AS
CREATE TABLE PARTITION
CREATE TRIGGER
CREATE TYPE
CREATE USER
CREATE VIEW
CREATE WEAK PASSWORD DICTIONARY
CURSOR
DEALLOCATE
DECLARE
DELETE
DO
DROP AUDIT POLICY
DROP CLIENT MASTER KEY
DROP COLUMN ENCRYPTION KEY
DROP DATABASE
DROP DATABASE LINK
DROP DIRECTORY
DROP FOREIGN DATA WRAPPER
DROP FUNCTION
DROP GLOBAL CONFIGURATION
DROP GROUP
DROP INDEX
DROP LANGUAGE
DROP MASKING POLICY
DROP MATERIALIZED VIEW
DROP MODEL
DROP NODE
DROP NODE GROUP
DROP OWNED
DROP PROCEDURE
DROP RESOURCE LABEL
DROP ROLE
DROP ROW LEVEL SECURITY POLICY
DROP SCHEMA
DROP SEQUENCE
DROP SERVER
DROP SYNONYM
DROP TABLE
DROP TABLESPACE
DROP TRIGGER
DROP TYPE
DROP USER
DROP VIEW
DROP WEAK PASSWORD DICTIONARY
EXECUTE
EXECUTE DIRECT
EXPDP DATABASE
EXPDP TABLE
EXPLAIN
EXPLAIN PLAN
FETCH
GRANT
IMPDP DATABASE CREATE
IMPDP RECOVER
INSERT
IMPDP TABLE
IMPDP TABLE PREPARE
LOCK
MOVE
MERGE INTO
PREDICT BY
PREPARE
PREPARE TRANSACTION
PURGE
REASSIGN OWNED
REINDEX
REFRESH INCREMENTAL MATERIALIZED VIEW
REFRESH MATERIALIZED VIEW
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
SHUTDOWN
START TRANSACTION
TIMECAPSULE TABLE
TRUNCATE
UPDATE
VACUUM
VALUES

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