Name: Yan Shiba Oracle Video Tutorial
Uploaded: 2022-04-18T15:21:37+8:00
Duration: 354 min 31 s
Description: "Yan Shiba Oracle Video Tutorial" explains the basic knowledge about Oracle, including the purpose of learning Oracle, basic add, delete, modify and query statements. Just like learning MySQL, it explains all common knowledge points about Oracle.

Chapter1Learning purpose: The purpose of learning oracle
04 minutes59 seconds
Chapter2Oracle Basics Explained: sqlplus connection and startup and shutdown instances
05 minutes15 seconds; sqlplus buffer operation
09 minutes33 seconds; sqlplus interacts with external programmers
05 minutes28 seconds; Using variables in sqlplus
09 minutes21 seconds; Column types and table creation
11 minutes28 seconds; constraint
20 minutes09 seconds; sequence
21 minutes03 seconds; synonyms
05 minutes23 seconds; Check for phrases
17 minutes18 seconds; subquery
04 minutes56 seconds; Join query
04 minutes06 seconds; view
04 minutes54 seconds; index
07 minutes04 seconds; affairs
14 minutes47 seconds
Chapter3Oracle improvement explanation: The first pl-sql program
07 minutes54 seconds; Variables and default value settings
09 minutes53 seconds; if-else control results
09 minutes02 seconds; while structure
05 minutes01 seconds; for loop
11 minutes23 seconds; loop loop
03 minutes30 seconds
Chapter4Oracle Advanced Course: Stored procedures and stored functions
14 minutes55 seconds; plsql interacts with database
18 minutes35 seconds; custom data type
19 minutes19 seconds; Quickly define data types using tables and columns
10 minutes45 seconds; Exception handling
09 minutes06 seconds; recursive function
05 minutes56 seconds; implicit cursor
14 minutes50 seconds; explicit cursor
15 minutes01 seconds; trigger
27 minutes24 seconds; Compile PHP-OCI8 to connect to oracle
26 minutes13 seconds

Yan Shiba Oracle Video Tutorial

About Instructor

php.cn