This tutorial demonstrates some of the PL/SQL features within Oracle SQL Developer, such as advanced searches and refactoring code.
This tutorial shows how to use the source code control feature in Oracle SQL Developer 3.0
This tutorial focuses on creating, compiling, running and debugging PL/SQL.
Watch as Steven explains what he means by hard-coding in PL/SQL.
That's right. VARCHAR2 declarations mean that you have to provide an "N" or constraint on the size of the variable. If you have such declarations all over your code, that's a form of hard-coding and you are likely to get hammered by VALUE_ERROR exceptions. This video shows how to fix this problem.
Since we write software using our brains, it is hard to avoid the impact of psychology and physiology of our brains on our code. This manifests quite clearly when it comes to hard-coding.
In this section of the tutorial, you learn how to how to use PL/SQL in the Oracle Express Edition. You learn about PL/SQL anonymous blocks, stored procedures, stored functions, and stored packages.