PLSQL -Key Points
Make code maintenance easier by:
• Documenting code with comments
• Developing a case convention for the code
• Developing naming conventions for identifiers and other objects
• Enhancing readability by indenting
All SQL functions are available in plsql
decode and group functions are not available in plsql.
When you are working with nulls, you can avoid some common mistakes by keeping in mind the following rules:
• Comparisons involving nulls always yield NULL.
• Applying the logical operator NOT to a null yields NULL.
• In conditional control statements, if the condition yields NULL, its associated sequence of statements is not executed.
sequences can be directly used in plsql in 11g :
DECLARE
l_employee_id NUMBER(10);
BEGIN
l_employee_id :=sequence.nextval;
END;
