Design considerations for PL/SQL Code

• Create Standard Constants and Exceptions
  
• Write and call local sub-programs
  Local sub-programs must be declared at thet end of the declaration section after all local variables
  
• Control run-time privileges of a subprogram
  
• Perform autonomous transactions
  
• Use NOCOPY hint
  
• Use PARALLEL_ENABLE
  
• Use Deterministic clause
  
• Use Bulk Binding and the RETURNING clause with DML