Which of the following statements is the conditional branching statement in SQL/

Question

Which of the following statements is the conditional branching statement in SQL/PSM?
Select one:

a. IF <condition>
ELSEIF <condition>       ...
ELSEIF <condition>
ELSE <statement list>
END IF

b. IF <condition> THEN <statement list>
ELSEIF <condition> THEN <statement list>
...
ELSEIF <condition> THEN <statement list>
ELSE <statement list>
END IF

c. IF <condition> THEN <statement list>
END IF

d. IF <condition
ELSE <statement list>
END IF

Explanation / Answer

Answer:b. IF <condition> THEN <statement list>
ELSEIF <condition> THEN <statement list>
...
ELSEIF <condition> THEN <statement list>
ELSE <statement list>
END IF

Explanation:

In this section, we discuss the SQL/PSM constructs for conditional (branching) statements and for looping statements. These will give a flavor of the type of con-structs that SQL/PSM has incorporated; then we give an example to illustrate how these constructs can be used.

The conditional branching statement in SQL/PSM has the following form:

IF <condition> THEN <statement list>
ELSEIF <condition> THEN <statement list>
...
ELSEIF <condition> THEN <statement list>
ELSE <statement list>
END IF

Related Questions

Navigate

• Browse (All)
• Browse W
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.