Easy Learning Oracle SQL: SQL for Beginner's Guide

by Yang Hu

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

127 pages, Kindle Edition

Published April 15, 2019