How are exceptions handled in PL/SQL? Give some of the internal exceptions' name?

• The default exception will be handled using WHEN others THEN:
  
  DECLARE
  
  BEGIN
  
  EXCEPTION
  
  WHEN exception1 THEN
  exception1-handling-statements
  WHEN exception2 THEN
  exception2-handling-statements
  WHEN exception3 THEN
  exception3-handling-statements
  ........
  WHEN others THEN
  exception3-handling-statements
  END;
  
  PL/SQL provides many pre-defined exceptions
  ACCESS_INTO_NULL
  CASE_NOT_FOUND
  COLLECTION_IS_NULL
  DUP_VAL_ON_INDEX
  INVALID_CURSOR
  INVALID_NUMBER
  ...& many more
• 9 years agoHelpfull: Yes(1) No(0)