ORACLE 10g
- 1. DML
- 1.1 Select
- 1.2 Update
- 1.3 Delete
- 1.4 Select into
- 2. DDL
- 2.1 create database
- 2.2 alter database
- 2.3 create table
- 2.4 alter table
- 2.5 drop table
- 2.6 create index
- 2.7 drop index
- 3. Where condition
- 4. Operator
- 4.1 Equal
- 4.2 not equal
- 4.3 Less than
- 4.4 Greater than
- 4.5 BETWEEN
- 4.6 LIKE
- 4.7 IN
- 5. Order by
- 6. Wild characters
- 7. SQL alias
- 8. SQL indexes
- 9. SQL view
- 10. NULL values
- 11. SQL constraints
- 11.1 NOT NULL
- 11.2 UNIQU E
- 11.3 Primary key
- 11.4 Foreign key
- 11.5 Check
- 11.6 Default
- 12. SQL joins
- 12.1 Join
- 12.2 Left
- 12.3 Right
- 12.4 Full
- 13. SQL UNION Operators
- 13.1 UNION
- 13.2 UNION ALL
- 14.SQL Functions
- 14.1 Aggregate Functions
- 14.1.1 AVG
- 14.1.2 COUNT
- 14.1.3 FIRST
- 14.1.4 MIN
- 14.1.5 SUM
- 14.2 Scalar Functions
- 14.2.1 UCASE
- 14.2.2 LCASE
- 14.2.3 MID
- 14.2.4 LEN
- 14.2.5 ROUND
- 15. SQL Group by
- 16. SQL Having
- 17.SQL Dual Table
PL/SQL
- 1.Triggers
- 1.1 Before trigger
- 1.2 After trigger
- 2. Stored Procedure
- 2.1 IN
- 2.2 OUT
- 2.3 IN OUT
- 3. Cursor
- 4. Functions