1 Write a procedure using user defined exception 2 write a procedure to get error, if updating end of the month. Etc....

Question

Accepted Answer

Creating procedures with user defined exceptions and handling errors when updating at end of month.

Create a procedure with a user defined exception using 'RAISE_APPLICATION_ERROR' and 'EXCEPTION' keywords.
Use 'TO_CHAR(SYSDATE, 'DD')' to check if it is the end of the month before updating.
Handle the error by raising an exception if the update is attempted at the end of the month.
Example: CREATE OR REPLACE PROCEDURE update_data AS BEGIN IF TO_CHAR(SYSDATE, 'DD') = '31' THEN RAISE_APPLICATION_ERROR(-20001, 'Cannot update at end of month'); END IF; -- Update statement here END;

Popular interview questions of Oracle Developer