Yang Hu

Easy Learning Oracle SQL 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 Installation2. Data Manipulation Language3. Tablespace4. User5. Insert Data6. Update Data7. Delete Data 8. Transaction9. Constraints10. One to One Association Table11. One to Many Association Table12. Many to Many Association Table13. Constraint Management14. Data Type15. Function16. Group By17. Inner Join18. Multi-table Equivalent Join19. Outer Join20. Seft Join21. GROUP BY and HAVING22. Sub Query23. Multi Row SubQuery24. Get Top N Rows25. Paging Query26. Collection27. View28. SEQUENCE29. Procedure30. PL/SQL 30.1 IF Statement 30.2 Case Statement 30.3 While Loop 30.4 For Loop31. Cursor 31.1 For Loop Cursor 31.2 Fetch Cursor32. Trigger