Example of explaining the structure of Oracle PL/SQL IF statement

Today, the editor will take you to understand the structure of Oracle PL/SQL IF sentences. The code explanation of this article is quite good for the editor, so I would like to share it with you for reference. Let's follow the editor and have a look.

The structure of the Oracle IF statement is similar to that of most languages

IF condition THEN expr;ELSIF condition THEN expr;ELSE expr;END IF

For example:

SELECT COUNT (DISTINCT INDEX_NAME) INTO CNT FROM USER_INDEXES WHERE TABLE_NAME=C1.TABLE_NAME; IF CNT > 1 THEN FOR C2 IN (SELECT DISTINCT INDEX_NAME FROM USER_INDEXES WHERE TABLE_NAME=C1.TABLE_NAME) LOOP EXECUTE IMMEDIATE 'ALTER INDEX' | | C2.INDEX_NAME | | 'REBUILD'; END LOOP; ELSIF CNT = 1 THEN EXECUTE IMMEDIATE' ALTER INDEX'| | C2.INDEX_NAME | | 'REBUILD' ELSE DBMS_OUTPUT.PUT_LINE (C1.TABLE_NAME | | 'THERE IS NO INDEXES NEED TO REBUILDING'); END IF

After reading the content of the appeal, do you have a general understanding of the structure of the Oracle PL/SQL IF sentence? If you want to know more about the content of the article, welcome to follow the industry information channel, thank you for reading!