The purpose of learning oracle

sqlplus connection and startup and shutdown instances

sqlplus buffer operation

sqlplus interacts with external programmers

Using variables in sqlplus

Column types and table creation

constraint

sequence

synonyms

Check for phrases

subquery

Join query

view

index

affairs

The first pl-sql program

Variables and default value settings

if-else control results

while structure

for loop

loop loop

Stored procedures and stored functions

plsql interacts with database

custom data type

Quickly define data types using tables and columns

Exception handling

recursive function

implicit cursor

explicit cursor

trigger

Compile PHP-OCI8 to connect to oracle