Documentation > USER GUIDE > SQL Manual > Data Manipulation

Data Manipulation

Data Manipulation


SELECT	SELECT INTO	WITH SELECT
INSERT VALUES	INSERT SELECT
UPDATE	MERGE
DELETE	TRUNCATE

PREPARE	EXECUTE	DEALLOCATE
CALL
SET	SET TIME ZONE	SET CURRENT_TIMEZONE

Transaction Management


START TRANSACTION	COMMIT	ROLLBACK
SET TRANSACTION	SET LOCAL TRANSACTION
SAVEPOINT	RELEASE SAVEPOINT	ROLLBACK TO SAVEPOINT

Development Commands


EXPLAIN	PLAN	TRACE
ANALYZE	SET OPTIMIZER

Pseudo Columns


CURRENT_SCHEMA	CURRENT_USER	CURRENT_DATE	CURRENT_TIME
CURRENT_TIMESTAMP	CURRENT_TIMEZONE	LOCALTIME	LOCALTIMESTAMP
LOCALTIMESTAMP	NEXT VALUE FOR