PL/SQL Tutorials

Cheat Sheets, Blogs

• http://plsql-tutorial.com/
• http://sql-plsql.blogspot.ch/
• http://www.stevenfeuerstein.com/learn/learn-plsql

Examples

select text from user_sources  -- show functions, procedures, packages

Visualizations

via http://www.ictedu.info/e-learning/oracle-pl-sql-programming/leksion-01

Videos

• Oracle OCA Series
• Part 1: Oracle SQL Plus Tutorial
• Part 1: Oracle SQL X Plus tutorial continues
• Part 2: Oracle Installation and database creation
• Part 3: Oracle database Instance Architecture
• Part 4: Oracle startup, shutdown, the installation file
• Part 5: Managing Tables, views, Constraints and Sequences in Oracle
• Part6: Oracle tutorial data moring utilities
• Part 7: Oracle tutorial PL/SQL Basics
• Part 8 : Procedures, Functons & Triggers
• Part 9: Oracle Tutorial – Managing Packages
• Part 10: Oracle Tutorial – Managing Undo
• Part 11: Create tablespace options in Oracle
• Part 12: Managing users in Oracle 10g
• Part 13: oracle net Services
• Part 14: Oracle : Shared server
• Part 15: Oracle security
• Part 16: Oracle Locks, Latches and Waits
• Part 17: Oracle performance
• Part 18: racle database backup and recovery concepts
• Part 19: Oracle recovery manager
• Part 20: Restore I recovery tactics
• Part 21: Oracle enterprise manager DB Console

via http://www.freestudentprojects.com/visual-basic/oracle/oracle-video-tutorial/

• PL SQL Best Practices with Steven Feuerstein