SELECT	retrieves records from one or more tables
FROM	specifies a list of tables and any attachments
WHERE	is used to filter the results
ORDER BY	is used for sorting records
GROUP BY	groups the results of one or more columns
HAVING	used in combination with GROUP BY to limit groups of returned strings
DISTINCT	removes duplicates from the resulting SELECT set
EXISTS	used in conjunction with a subquery
INSERT	used to insert one or more records into an Oracle table
INSERT ALL	is used to add multiple lines using a single INSERT operator
UPDATE	used to update existing table entries in the Oracle database
DELETE	used to remove one or more records from a table in Oracle
TRUNCATE TABLE	is used to remove all records from the table in Oracle
UNION	removes repetitive lines between SELECT requests
UNION ALL	returns all rows from the query and does not delete repeating rows
INTERSECT	returns the intersection of 2 sets of results
MINUS	returns one data set minus another data set
PIVOT	used to rotate rows into columns
Subqueries	subqueries

Data Types	Data Types
Literals	Such as text, integer, number and datetime
Declaring Variables	Announcement of variables, constants
Comments within SQL	SQL comments are used to comment on program code
Procedures	Creation and removal of procedures
Functions	Create and delete functions
Triggers	Create, delete, enable and disable triggers
Dynamic SQL	Dynamic SQL
Packages	Packages and package bodies – create, delete
Sequences	Sequences
Synonyms	Synonyms
Aliases	Aliases (aliases) for tables or columns
WITH	Operator WITH

Cursors (CREATE CURSOR)
Declare a Cursor
Operators
OPEN	FETCH	CLOSE
Cursor Attributes: %FOUND, %NOTFOUND, %ISOPEN, ROWCOUNT
SELECT FOR UPDATE
WHERE CURRENT OF

CREATE TABLE	Create a table
CREATE TABLE AS	Create a table from the definition and data of another table
ALTER TABLE	Add, change or delete columns in the table; rename the table
DROP TABLE	Delete the table (no recovery option)
GLOBAL TEMPORARY TABLES	Create a global time table
LOCAL TEMPORARY TABLES	Create a local time table
VIEW	Virtual tables (views of other tables)

CREATE USER	Operator to create an account in the database
DROP USER	Operator to delete a user from the database
ALTER USER (Change Password)	Change user password in Oracle
Find Users in Oracle	Search for a user in Oracle
Find Users logged into Oracle	Search for users logged in to Oracle
TABLESPACE	Tabular spaces create, modify, delete. Search for default table spaces . Default setting of tabular spaces
Grant/Revoke PRIVILEGES	Providing privileges to users in Oracle
ROLES	Creating a role, granting/disabling privileges to a role, enabling/disabling a role, setting a default role and removing a role
SCHEMA	The scheme allows logical grouping of objects in an Oracle database

Primary Keys	Primary Keys
Foreign Keys	External keys
Foreign Keys with cascade delete	External keys with cascading removal
Foreign Keys with set null on delete	External keys with “set null on delete”
Drop a foreign key	Deletion of external key
Disable a foreign key	Turn off external key
Enable a foreign key	Turning on the external key
Indexes	Indexes
Unique constraints	Unique restrictions
Check constraints	Checking restrictions

Oracle conditions
AND	logical operator and
OR	logical operator or
AND & OR	logical operators and/or
NOT	logical operator not
LIKE	correlates data with a template
REGEXP_LIKE	uses regular expressions
IN	determines whether the value or list of values corresponds to the expression in the specified set
IS NULL	NULL check
IS NOT NULL	NOT NULL check
BETWEEN	is used to obtain values within a range

Collection method	Type	Description
DELETE	Procedure	Removes elements from the collection.
TRIM	Procedure	Removes elements from the end of varray or Nested Tables.
EXTEND	Procedure	Adds elements to the end of varray or Nested Tables.
EXISTS	Function	Returns TRUE if and only if a certain varray or Nested Tables element exists.
FIRST & LAST	Functions	FIRST returns the first, LAST the last index in the collection.
COUNT	Function	Returns the number of items in the collection.
LIMIT	Function	Returns the maximum number of items that a collection can have.
PRIOR & NEXT	Functions	PRIOR returns the index that precedes the specified index, NEXT returns the index that follows the specified index.

MULTISET UNION	Returns the merger of the two collections
MULTISET UNION DISTINCT	Returns the merger of the two collections with a dystinct (removes duplicates)
MULTISET INTERSECT	Returns the intersection of two collections
MULTISET INTERSECT DISTINCT	Returns the intersection of the two collections with distinct (removes duplicates)
SET	Returns a collection with dystinct (i.e. a collection without takes)
MULTISET EXCEPT	Returns the difference (truncation) between the two collections
MULTISET EXCEPT DISTINCT	Returns the difference (truncation) between two collections with distinct (removes duplicates)

Oracle PL/SQL tutorial

Oracle PL/SQL Functions