| SQL Data Definition Language |
Using The SQL*PLUS Tool |
 |
CREATE TABLE STATEMENT |
|
SELECT |
|
NOT NULL |
|
DEFAULT |
|
ALTER, DROP |
|
DESCRIBE, RENAME |
|
|
INTERACTIVE SQL WITH SQL*PLUS |
|
Graphical SQL*Plus |
|
EXIT or QUIT |
|
HOST or $ |
|
SPOOL |
|
START or @ |
|
LIST, SAVE, GET |
|
RUN or / |
|
EDIT, APPEND, CHANGE, DEL, INPUT |
|
| SQL Data Manipulation Language |
Introduction to SQL Queries |
|
ABOUT SQL DML |
|
SELECT, INSERT |
|
INSERT Using SELECT |
|
DELETE, UPDATE |
|
ABOUT TRANSACTIONS |
|
ROLLBACK, COMMIT, SAVEPOINT |
|
COMPLEX TABLE REFERENCES |
|
|
SELECT |
|
DISTINCT |
|
ALIAS NAMES |
|
| Building a WHERE Clause |
Ordering the RESULT Table |
|
EQUALITY, Inequality |
|
BOOLEAN |
|
NULL AND BETWEEN |
|
IS [NOT] NULL |
|
[NOT] BETWEEN |
|
[NOT] LIKE |
|
IN |
|
|
ABOUT THE ORDER BY CLAUSE |
|
INCLUDING MULTIPLE COLUMNS |
|
SPECIFYING THE SORT SEQUENCE |
|
NULL VALUES AND ORDER BY |
|
SORTING BY UN-SELECTED COLUMNS |
|
REFERRING TO COLUMN ALIASES |
|
| Pseudo Columns and Functions |
Joining Tables |
|
THE PSEUDO COLUMNS |
|
ROWNUM, SYSDATE, USER & UID |
|
THE DUAL TABLE |
|
|
EQUI-JOIN |
|
REFLEXIVE JOIN |
|
NON KEY-JOIN |
|
OUTER JOIN |
|
| Using Set Operators Upon Tables |
About Summary Functions |
|
SET OPERATOR EXAMPLES |
|
UNION, INTERSECT, MINUS |
|
PERFORMING A FULL OUTER JOIN |
|
|
| Using Subqueries |
Creating & Selecting Groups |
|
|
|
GROUP BY Example |
|
SELECTING DATA FROM THE BASE TABLES |
|
HAVING |
|
| Creating & Using Views |
Indexes & Synonyms |
| Understanding The Data Dictionary |
|
|
ABOUT THE DATA DICTIONARY |
|
Query DD: USER_TABLES, USER_TAB_COLUMNS, USER_OBJECTS |
|
|
