We're retiring Oracle Learning Library by the end of 2025.
Explore tutorials and labs on docs.oracle.com/learn or access free learning content on the Oracle Learning YouTube channel.For product documentation, visit Oracle Help Center.
Join Steven Feuerstein, well-known author and recognized Oracle PL/SQL expert, on a video tour that leads you to techniques which help you write practically perfect PL/SQL.
Release Date: 07-FEB-2015
Watch as Steven explains what he means by hard-coding in PL/SQL.
Duration: 8 minutes
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.
Duration: 3.5 minutes
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.