SQL Command Types
Data Definition Language (DDL) .
The query and manipulate data in existing schema objects. These commands do not implicitly commit the current transaction.
LIKE
ALTER SEQUENCE DROP INDEX
ALTER TABLE DROP PROCEDURE
ALTER TRIGGER CREATE SEQUENCE
ALTER USER DROP SEQUENCE
ALTER VIEW CREATE TABLE
ALTER SEQUENCE DROP INDEX
ALTER TABLE DROP PROCEDURE
ALTER TRIGGER CREATE SEQUENCE
ALTER USER DROP SEQUENCE
ALTER VIEW CREATE TABLE
Data Manipulation Language (DML).
LIKE
DELETE
INSERT
UPDATE
DELETE
INSERT
UPDATE
Transaction Control Commands.
LIKE
COMMIT
ROLLBACK
SAVEPOINT
SET TRANSACTION
COMMIT
ROLLBACK
SAVEPOINT
SET TRANSACTION
Pseudocolumns.
LIKE
CURRVAL
NEXTVAL
LEVEL
ROWID
ROWNUM
NEXTVAL
LEVEL
ROWID
ROWNUM
No comments:
Post a Comment