Section1 sqlplus connection and startup and shutdown instances

05 minutes15 seconds

Section2 sqlplus buffer operation

09 minutes33 seconds

Section3 sqlplus interacts with external programmers

05 minutes28 seconds

Section4 Using variables in sqlplus

09 minutes21 seconds

Section5 Column types and table creation

11 minutes28 seconds

Section6 constraint

20 minutes09 seconds

Section7 sequence

21 minutes03 seconds

Section8 synonyms

05 minutes23 seconds

Section9 Check for phrases

17 minutes18 seconds

Section10 subquery

04 minutes56 seconds

Section11 Join query

04 minutes06 seconds

Section12 view

04 minutes54 seconds

Section13 index

07 minutes04 seconds

Section14 affairs

14 minutes47 seconds

Section1 The first pl-sql program

07 minutes54 seconds

Section2 Variables and default value settings

09 minutes53 seconds

Section3 if-else control results

09 minutes02 seconds

Section4 while structure

05 minutes01 seconds

Section5 for loop

11 minutes23 seconds

Section6 loop loop

03 minutes30 seconds

Section1 Stored procedures and stored functions

14 minutes55 seconds

Section2 plsql interacts with database

18 minutes35 seconds

Section3 custom data type

19 minutes19 seconds

Section4 Quickly define data types using tables and columns

10 minutes45 seconds

Section5 Exception handling

09 minutes06 seconds

Section6 recursive function

05 minutes56 seconds

Section7 implicit cursor

14 minutes50 seconds

Section8 explicit cursor

15 minutes01 seconds

Section9 trigger

27 minutes24 seconds

Section10 Compile PHP-OCI8 to connect to oracle

26 minutes13 seconds