ORACLE PLSQL - EXCEPTION

1. CREATE INDEX
2. DECODE
3. TO_CHAR
4. TO_DATE
5. SELECT
6. GRANT
7. INSERT
8. TUNNING
9. UPDATE
10. CREATE USER

EXCEPTION

	EXCEPTION
	   WHEN NO_DATA_FOUND THEN
	      code
	   WHEN OTHERS THEN
	      code

	DECLARE
	   dummy NUMBER;
	BEGIN
	   SELECT count(*) INTO dummy FROM dual;

	EXCEPTION
	   WHEN NO_DATA_FOUND THEN
	      NULL;
	   WHEN OTHERS THEN
	      NULL;
	END;

	DUP_VAL_ON_INDEX 	ORA-00001
	TIMEOUT_ON_RESOURCE 	ORA-00051
	TRANSACTION_BACKED_OUT 	ORA-00061
	INVALID_CURSOR 		ORA-01001
	NOT_LOGGED_ON 		ORA-01012
	LOGIN_DENIED 		ORA-01017
	NO_DATA_FOUND 		ORA-01403
	TOO_MANY_ROWS 		ORA-01422
	ZERO_DIVIDE 		ORA-01476
	INVALID_NUMBER 		ORA-01722
	STORAGE_ERROR 		ORA-06500
	PROGRAM_ERROR 		ORA-06501
	VALUE_ERROR 		ORA-06502
	CURSOR_ALREADY_OPEN 	ORA-06511