In this video, I'll explain what private temporary tables are, how to create them, what they're used for, and show examples.
Enjoy watching.
Lesson repository: https://github.com/kivilev/oracle_dbd...
Contents:
0:00 - Introduction
0:12 - Temporary Tables
0:41 - Private Temporary Tables
1:16 - Syntax for Creating a Private Temporary Table
1:40 - Differences Between Temporary Tables
3:06 - Using Private Temporary Tables
3:57 - Example 1. Creation
4:45 - Example 2. Naming
5:51 - Example 3. Features
7:09 - Example 4. Using in PL/SQL
7:53 - Conclusion
-------
Follow my Telegram channel: https://t.me/oracle_dbd
All about Oracle DBMS development. Theory, practice, SQL, PL/SQL, problems, certification, and much more.
If you need advice, have questions, or want to take training, write to me on Telegram - https://t.me/denis_dbd