Description:
Description
The complexity of life, because they do not understand to simplify the complex, to simplify the complexity, simple is the beginning of wisdom.
From the essence of practice, to briefly explain the concept, and vividly cultivate programming interest, this book easy and quickly learn Oracle SQL.
1. Oracle Installation
2. Data Manipulation Language
3. Tablespace
4. User
5. Insert Data
6. Update Data
7. Delete Data
8. Transaction
9. Constraints
10. One to One Association Table
11. One to Many Association Table
12. Many to Many Association Table
13. Constraint Management
14. Data Type
15. Function
16. Group By
17. Inner Join
18. Multi-table Equivalent Join
19. Outer Join
20. Seft Join
21. GROUP BY and HAVING
22. Sub Query
23. Multi Row SubQuery
24. Get Top N Rows
25. Paging Query
26. Collection
27. View
28. SEQUENCE
29. Procedure
30. PL/SQL
30.1 IF Statement
30.2 Case Statement
30.3 While Loop
30.4 For Loop
31. Cursor
31.1 For Loop Cursor
31.2 Fetch Cursor
32. Trigger