Yan Shiba Oracle Video Tutorial

• Chapter1 Learning purpose
• 1-1 The purpose of learning oracle
• Chapter2 Oracle Basics Explained
• 2-1 sqlplus connection and startup and shutdown instances
• 2-2 sqlplus buffer operation
• 2-3 sqlplus interacts with external programmers
• 2-4 Using variables in sqlplus
• 2-5 Column types and table creation
• 2-6 constraint
• 2-7 sequence
• 2-8 synonyms
• 2-9 Check for phrases
• 2-10 subquery
• 2-11 Join query
• 2-12 view
• 2-13 index
• 2-14 affairs
• Chapter3 Oracle improvement explanation
• 3-1 The first pl-sql program
• 3-2 Variables and default value settings
• 3-3 if-else control results
• 3-4 while structure
• 3-5 for loop
• 3-6 loop loop
• Chapter4 Oracle Advanced Course
• 4-1 Stored procedures and stored functions
• 4-2 plsql interacts with database
• 4-3 custom data type
• 4-4 Quickly define data types using tables and columns
• 4-5 Exception handling
• 4-6 recursive function
• 4-7 implicit cursor
• 4-8 explicit cursor
• 4-9 trigger
• 4-10 Compile PHP-OCI8 to connect to oracle