Basic SQL query with suitable schema
Basic PL/SQL block with suitable example.
Conditional statement with suitable example
Selection statement with suitable example
Completion of this lesson you should understand basic structure of PL/SQL and programming concept. and also able to work with database table.
I also give realtime example so that you use these technique to your project.
you should able to understand basic knowledge of SQL query and PL/SQL Programming.