[SQL Automation] PL/SQL for Immediate Practical Use

What is PL/SQL?

Oracle PL/SQL is the programming language used in the Oracle database.
PL/SQL is an abbreviation for Procedural Language/Structured Query Language, and is a procedural programming language.

It combines the features of query languages.
This language is based on SQL statements and adds programming elements to provide powerful database-based operations.

Allows you to implement business logic.

Regarding PL/SQL
What Instructor Yoo Yeon-su Wants to Tell You

After learning SQL, I felt a gentle pleasure in searching data with my own hands.
However, when working with SQL, you will experience monotonous tasks repeated every day.
Automating these repetitive, simple tasks is why we use PL/SQL.
PL/ SQL allows me to program, which allows me to put my own creative thinking into SQL.
Learning PL/ SQL will be more fun than just knowing SQL.

This is the employment or job change status of students who took Professor Yoo Yeon-su's PL/SQL class.

Source: https://cafe.daum.net/oracleoracle/SDMs/441

It is constantly being updated.

Lecture Contents:

1. Setting up a PL/SQL development environment

2. Why you should learn PL/SQL

3. Understanding PL/SQL Variables

4. Functions used in PL/SQL

5. Understanding PL/SQL blocks

6. How to write DML statements in PL/SQL

7. If and loop statements in PL/SQL

8. Double loop statement in PL/SQL

9. Debugging Code Using Labels

10. PL/SQL record combination variable

11. PL/SQL Cursor Statement

12. Cursor statement using subquery

13. Exception handling in PL/SQL

14. Using exception trap functions

15. Procedures in PL/SQL

16. Functions in PL/SQL

17. Composite Variables in PL/SQL Records and Collections

18. Improving DML statement performance in PL/SQL

19. Improving FOR loop performance in PL/SQL

20. Improving PL/SQL Procedure Performance

21. Creating SQL Automation Scripts1

22. Creating SQL Automation Scripts2

23. Creating SQL Automation Scripts3

24. Creating SQL Automation Scripts4

25. Writing PL/SQL code using ChatGPT

You can learn SQL by mastering the following 4-step skills. This subject is the 2nd step of the two.