Exit command in PL / SQL

Question

Exit command in PL / SQL

Navigation

#1 by (1 votes)

1

I have noticed that the command exit works the same as a break, it stops executing the current block and passes to the next one, but which command can stop the whole procedure in PL / SQL?

sql oracle pl-sql

asked by anonymous 05.08.2018 / 20:11

1 answer

bringing the p tag to the front of a div Query in SQL SERVER 2017

score 1 · Accepted Answer

According to the documentation , to end the execution of the routine you you must use the RETURN command.

Rectifying something you mentioned, the Exit would be to terminate looping.

The EXIT statement forces you to complete unconditionally. When an EXIT statement is encountered, the loop completes immediately and control passes to the next statement.

Free translation:

The EXIT command forces a loop to be terminated unconditionally. When the EXIT statement is found, the loop is terminated immediately and control is passed to the command line after the loop

I hope this helps.