Display a message to check whether the record is deleted or not with the use of SQL%NOTFOUND

Posted Date: 11 May 2008 Resource Type: Articles/Knowledge Sharing Category: Computer & Technology

Posted By: Nikky Member Level: Gold
Rating:

Points: 2

BEGIN
DELETE EMP WHERE EMPNO = &EMPNO;
IF SQL%NOTFOUND THEN
DBMS_OUTPUT.PUT_LINE(‘RECORD NOT DELETED’);
ELSE
DBMS_OUTPUT.PUT_LINE(‘RECORD DELETED’);
END IF;
END;

Responses

No responses found. Be the first to respond and make money from revenue sharing program.

Feedbacks

Popular Tags

What are tags ?

Search Tags

(No tags found.)

Post Feedback

This is a strictly moderated forum. Only approved messages will appear in the site. Please use 'Spell Check' in Google toolbar before you submit.
You must Sign In to post a response.

	Next Resource: TYPES OF CURSORS IN PL/SQL
	Previous Resource: Meaning of TRIGGERS In PL/SQL
	Return to Discussion Resource Index
	Post New Resource
	Category: Computer & Technology

Post resources and earn money!

Related Resources

Fresher Jobs

Resources

Colleges

Display a message to check whether the record is deleted or not with the use of SQL%NOTFOUND

Responses

Post Feedback