SQL and ORACLE Commands

Index of SQL Commands
SQL TutorialLearn what SQL (Structured Query Language) is, and where and how it is used.
SQL TableSQL Database Tables are the foundation of every RDBMS (Relational Database Management System). Learn more about SQL tables here.
SQL SELECTLearn how to use the SELECT SQL statement to retrieve data from a SQL database table.
SQL SELECT INTOLearn how to use the SQL SELECT INTO statement to copy data between database tables.
SQL DISTINCTLearn how to use the SQL DISTINCT clause together with the SQL SELECT keyword, to return a dataset with unique entries for certain database table column.
SQL WHEREThe SQL WHERE command is used to specify selection criteria, thus restricting the result of a SQL query.
SQL LIKEThe SQL LIKE clause is used along with the SQL WHERE clause and specifies criteria based on a string pattern.
SQL INSERT INTOLearn how to use the SQL INSERT INTO clause to insert data into a SQL database table.
SQL UPDATELearn how to use the SQL UPDATE statement to update data in a SQL database table.
SQL DELETELearn how to use the SQL DELETE statement to delete data from a SQL database table.
SQL ORDER BYLearn how to use the SQL ORDER BY statement to sort the data retrieved in your SQL query.
SQL OR & ANDLearn how to use the SQL OR & AND keywords together with the SQL WHERE clause to add several conditions to your SQL statement.
SQL INThe SQL IN clause allows you to specify discrete values in your SQL WHERE search criteria.
SQL BETWEENThe SQL BETWEEN & AND keywords define a range of data between 2 values.
SQL AliasesSQL aliases can be used with database tables and/or with database table columns, depending on task you are performing.
SQL COUNTThe SQL COUNT aggregate function is used to count the number of rows in a database table.
SQL MAXThe SQL MAX aggregate function allows us to select the highest (maximum) value for a certain column.
SQL MINThe SQL MIN aggregate function allows us to select the lowest (minimum) value for a certain column.
SQL AVGThe SQL AVG aggregate function selects the average value for a certain table column.
SQL SUMThe SQL SUM aggregate function allows selecting the total for a numeric column.
SQL GROUP BYThe SQL GROUP BY statement is used along with the SQL aggregate functions like SUM to provide means of grouping the result dataset by certain database table column(s).
SQL HAVINGThe SQL HAVING clause is used to restrict conditionally the output of a SQL statement, by a SQL aggregate function used in your SELECT list of columns.
SQL JOINThe SQL JOIN clause is used whenever we have to select data from 2 or more tables.
An A-Z Index of Oracle SQL Commands (version 9.2)
ANALYZE
AUDIT
CALL
Cluster - CREATE CLUSTER
- ALTER CLUSTER
- DROP CLUSTER
COMMENT
COMMIT
CONNECT
CONSTRAINT - Add / Enable
Context - CREATE CONTEXT
- DROP CONTEXT
Controlfile - CREATE CONTROLFILE
Database - CREATE DATABASE
- ALTER DATABASE
DELETE
DESCRIBE
Dimension - CREATE DIMENSION
- ALTER DIMENSION
- DROP DIMENSION
Directory - CREATE DIRECTORY
- DROP DIRECTORY
EXEC
EXECUTE IMMEDIATE
EXPLAIN PLAN
Function - CREATE FUNCTION
- ALTER FUNCTION
- DROP FUNCTION
GRANT
Index - CREATE INDEX
- ALTER INDEX
- DROP INDEX
Indextype - CREATE INDEXTYPE
- DROP INDEXTYPE
INSERT
INTERSECT
Java - CREATE JAVA
- ALTER JAVA
- DROP JAVA
Library - CREATE LIBRARY
- DROP LIBRARY
Link - CREATE DATABASE LINK
- DROP DATABASE LINK
LOCK TABLE
Mview - CREATE MATERIALIZED VIEW
- ALTER MATERIALIZED VIEW
- DROP MATERIALIZED VIEW
- CREATE MATERIALIZED VIEW LOG
- ALTER MATERIALIZED VIEW LOG
- DROP MATERIALIZED VIEW LOG
MINUS
NOAUDIT
Operator - CREATE OPERATOR
- DROP OPERATOR
Outline - CREATE OUTLINE
- ALTER OUTLINE
- DROP OUTLINE
Package - CREATE PACKAGE/BODY
- ALTER PACKAGE
- DROP PACKAGE
Pfile - CREATE PFILE
Procedure - CREATE PROCEDURE
- ALTER PROCEDURE
- DROP PROCEDURE
Profile - CREATE PROFILE
- ALTER PROFILE
- DROP PROFILE
RECOVER
RENAME
Resource - ALTER RESOURCE COST
REVOKE
RMAN - Recovery Manager
Role - CREATE ROLE
- SET ROLE
- ALTER ROLE
- DROP ROLE
ROLLBACK
Rollback - CREATE ROLLBACK SEGMENT
- ALTER ROLLBACK SEGMENT
- DROP ROLLBACK SEGMENT
SAVEPOINT
Schema - CREATE SCHEMA
SELECT
Sequence - CREATE SEQUENCE
- ALTER SEQUENCE
- DROP SEQUENCE
Session - ALTER SESSION
SHUTDOWN
SNAPSHOT
SPfile - CREATE SPFILE
STARTUP
Statistics - ASSOCIATE STATISTICS
- DISASSOCIATE STATISTICS
Synonym - CREATE SYNONYM
- DROP SYNONYM
System - ALTER SYSTEM
Table - CREATE TABLE
- ALTER TABLE
- DROP TABLE
Tablespace - CREATE TABLESPACE
- ALTER TABLESPACE
- DROP TABLESPACE
- CREATE TEMPORARY TABLESPACE
Transaction - SET TRANSACTION
Trigger - CREATE TRIGGER
- ALTER TRIGGER
- DROP TRIGGER
TRUNCATE
Type - CREATE TYPE
- ALTER TYPE
- DROP TYPE
- CREATE TYPE BODY
- DROP TYPE BODY
UPDATE
UNION
User - CREATE USER
- ALTER USER
- DROP USER
View - CREATE VIEW
- ALTER VIEW
- DROP VIEW