Shulou(Shulou.com)06/01 Report--

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!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.