plsql if then 使用

There are three different syntaxes for these types of statements.

Syntax #1: IF-THEN

IF condition THEN

         {...statements...}

END IF;

 

Syntax #2: IF-THEN-ELSE

IF condition THEN

         {...statements...}

ELSE

         {...statements...}

END IF;

 

Syntax #3: IF-THEN-ELSIF

IF condition THEN

         {...statements...}

ELSIF condition THEN

         {...statements...}

ELSE

         {...statements...}

END IF;