Parsing

Parsing: Parsing a statement means breaking down the statement, so that it can be executed. When oracle server parses a SQL statement, it first checks for semantic and syntactical errors in statements. Oracle uses shared the SQL area for parsing (Parse tree).

Programming standards:
• Using the standard template form.
• Naming conventions for blocks, buttons, record groups, etc.
• Proper Indentation.
• Naming and declaration of identifiers (local variables, global variables, cursors, etc.)
• Always use %Type and %RecType
• Exception handling and error messages
• Proper commenting
• Using performance standard code in Validation and data fetching