Structure of Oracle PL/SQL IF statements

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

IF condition then expr; elsif condition then expr; ELSE expr; END IF;

As an 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; 

This article is from the "linuxoracle" blog, make sure to keep this source http://onlinekof2001.blog.51cto.com/3106724/1615011

Structure of Oracle PL/SQL IF statements