Oracle 应用程序开发和 PL - SQL 初学者
Oracle Application Development and PL - SQL for beginners
- 2. Oracle Database Setup
- 2. Oracle installation requirements
- 3. Download Oracle
- 4. Install Oracle
- 5. What is SQLPlus
- 6. Connect SQLPlus to Oracle
- 7. How to start and stop Oracle Database
- 8. What is SQL Developer
- 9. Connect SQL Developer to Oracle
- 11. Download sample schemas
- 12. Unlock sample HR Schema Account
- 13. Unlock sample schema tables
- 14. Connect schema account to Oracle
- 15. What are TNS Names
- 16. Creating TNS Names
- 17. Connect Oracle with TNS Names
- 19. Install TOAD
- 20. Connect TOAD to Oracle
- 21. Create a new connection in TOAD
- 3. Programming with PLSQL
- 1. What is PLSQL
- 2. Viewing HR Schema Objects with SQLPlus
- 3. Viewing employees table properties with SQLPlus
- 4. Viewing employees table data with SQLPlus
- 5. PLSQL Variables
- 6. PLSQL Variable declaration
- 7. PLSQL Variable Assignment
- 8. PLSQL Variable Anchors
- 9. PLSQL Block structure
- 10. Execute a PLSQL annonymous block using TOAD
- 11. Edit a PLSQL Code block using SQL Plus
- 12. Executing PLSQL Variable Assignemt using TOAD
- 13. Intitializing Variables in PLSQL using TOAD
- 14. PLSQL Literals
- 15. PLSQL Constants using TOAD
- 16. Variable Scopes in PLSQL using TOAD
- 17. Introduction to PLSQL Functions
- 18. Creating functions
- 19. Creating PLSQL Functions using TOAD
- 20. What are PLSQL Stored Procedures
- 21. How to create stored procedure in TOAD
- 22. How to execute or call a stored procedure in TOAD
- 23. PLSQL Nested Block
- 24. Syntax for Nested PLSQL Blocks
- 25. Nested Block Scopes
- 26. Creating a nested PLSQL Block with TOAD
- 28. PLSQL IF Statements
- 29. PLSQL If statement examples using TOAD
- 30. PLSQL CASE Statement
- 31. PLSQL CASE Statement Example using TOAD
- 32. PLSQL Searched Case Statement
- 33. PLSQL Searched Case Statement Example using TOAD
- 34. PLSQL CURSOR
- 35. PLSQL Cursor Example using Toad
- 36. Introduction to PLSQL Package
- 37. Creating a PLSQL Package Specification using TOAD
- 38. Creating a PLSQL Package Body using TOAD
- 39. Referencing PLSQL Package Elements using Toad
- 4. Oracle Application Development -APEX
- 2. Oracle APEX Installation Requirements
- 3. Download Oracle APEX
- 4. Installing Oracle APEX
- 5. Installing Java Development Kit - JDK
- 6. Download Oracle Rest Data Services
- 7. Installing Oracle Rest Data Services
- 8. How to sign into Oracle APEX
- 9. How to create a workspace
- 10. How to create a new APEX user
- 12. Sign in to APEX as new User
- 13. How to request a cloud APEX Workspace
- 14. How to activate a cloud APEX Workspace
- 15. Build applications from datasets