PL/SQL: IF ... THEN ... GOTO in one line of code

PL/SQL: IF ... THEN ... GOTO in one line of code 28 Apr 2016

No specific Bitcoin Bounty has been announced by author. Still, anyone could send Bitcoin Tips to those who provide a good answer.

Can I write IF ... THEN ... GOTO statements in one single line of code in Oracle PL/SQL?

Tags: oracle, plsql

Edited Apr 28'16 at 10:26

lampego1@qrid

Created Mar 15'16 at 15:40

alex

ADD COMMENT | SEND TIPS

Internet users could send Bitcoin Tips to you if they like your answer!

Sure you can, here is the syntax example:

    if cursor_record.error_code is not null then goto validation_error; end if;
    ....
    ....


    <<validation_error>>
    -- do something

Edited Mar 15'16 at 15:46

alex

Created Mar 15'16 at 15:45

alex

ADD COMMENT

FavScripts.com is a free tool to save your favorite scripts and commands, then quickly find and copy-paste your commands with just few clicks.

Boost your productivity with FavScripts.com!