| Defining Database Objects |
Database Security |
 |
CREATING AN APPLICATION SCHEMA |
|
TRUNCATE |
|
Difference From DELETE and DROP TABLE |
|
CREATE INDEX / DROP INDEX |
|
USER_IND_COLUMNS |
|
ALTER VIEW |
|
USER_UPDATABLE_COLUMNS |
|
DEFINING SEQUENCES |
|
CREATE SEQUEN |
|
NEXTVAL, CURRVAL |
|
ALTER, DROP SEQUENCE |
|
CREATE SYNONYM / DROP SYNONYM |
|
|
USER SCHEMA PASS_A |
|
ABOUT OBJECT SECURITY |
|
GRANT, REVOKE |
|
| SQL Functions (CHARACTER) |
SQL Functions (NON-CHARACTER) |
|
CHARACTER FUNCTIONS |
|
UPPER(), LOWER(), INITCAP() |
|
CHR(), ASCII() |
|
RPAD(), RTRIM() |
|
DECODE(), SUBSTR() |
|
INSTR(), TRANSLATE() |
|
REPLACE() |
|
GREATEST(), LEAST() |
|
SOUNDEX() |
|
|
GREATEST(), ABS() |
|
ROUND(), TRUNC(), SIGN() |
|
TO_CHAR() |
|
Format Elements: YYYY, DDTH, FM, RR |
|
TO_DATE() Exam |
|
MONTHS_BETWEEN() |
|
ADD_MONTHS(), LAST_DAY() |
|
LAST_DAY(), NEXT_DAY() |
|
TRUNC(), ROUND() Dates |
|
NULL VALUE FUNCTI_ |
|
| Advanced SQL Language Constructs |
Protecting Tables with Declarative Constraints |
|
CASE EXPRESSION |
|
COALESCE() FUNC_SCE |
|
|
NOT NULL CONSTRAINT |
|
CHECK CONSTRAINT |
|
UNIQUE CONSTRAINT |
|
PRIMARY KEY CONSTRAINT |
|
REFERENCES CONSTRAINT |
|
ON DELETE CASCADE |
|
ON DELETE SET NULL |
|
| Maintaining Constraint Definitions |
Enhancing Groups with Rollup & Cube |
|
DROP TABLE CASCADE |
|
ENABLING & DISABLING CONSTRAINTS |
|
VALIDATE NEW TRANSACTIONS ONLY |
|
DEFERRED ENFORC_D |
|
SET CONSTRAINTS DEFERRED |
|
MANAGING CONSTRAINT EXCEPTIONS |
|
CONSTRAINTS |
|
DATA DICTIONARY STORAGE |
|
USER_CONSTRAINTS |
|
CONSTRAINT_TYPE Code Explanation |
|
|
USING ROLLUP |
|
GROUPING() |
|
CUBE |
|
| Advanced SQL*Plus Reports |
Building SQL*Plus Scripts |
|
BREAK, COMPUTE |
|
COLUMN, TTITLE / BTITLE |
|
|
XSQL File |
|
DEFINE / UND |
|
ACCEPT |
|
START OR @ |
|
PROMPT, PAUSE |
|
| Processing Hierarchies |
Advanced SQL & SQL*Plus Features |
|
:N HIERARCHY (SUPERVISION) |
|
M:N HIERARCHY (BILL-OF-MATERIALS) |
|
|
