Easy Learning Oracle SQL SQL for Beginner's Guide

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