Thursday, August 18, 2016

PLSQL - Key Points

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;

Featured Post

Will the data from Oracle Database be lost after formatting the system in which it is installed?

So Someone asked me a question,  Will the data from Oracle Database be lost after formatting the system in which it is installed? Since the ...

Popular Posts