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

0

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

Tags: ,

1 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
1

Too many commands? Learning new language?

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

Boost your daily productivity with FavScripts.com!

Post Answer