[Solved] Identify the error in this PL/pgSQL snippet:DO $ DECLARE n INT := 3; BEGIN IF n = 1 THEN RAISE NOTICE 'One'; ELSIF n = 2 THEN RAISE NOTICE 'Two'; ELSE RAISE NOTICE 'Other' END IF; END $; | PostgreSQL

PostgreSQL - PL/pgSQL Fundamentals

Identify the error in this PL/pgSQL snippet:

DO $$
DECLARE
  n INT := 3;
BEGIN
  IF n = 1 THEN
    RAISE NOTICE 'One';
  ELSIF n = 2 THEN
    RAISE NOTICE 'Two';
  ELSE
    RAISE NOTICE 'Other'
  END IF;
END $$;

AIncorrect use of ELSIF instead of ELSEIF.

BMissing semicolon after the last RAISE NOTICE statement.

CVariable n is not declared properly.

DMissing END DO statement.

Step-by-Step Solution

Solution:

Step 1: Check syntax of RAISE NOTICE statements
Each statement must end with a semicolon.
Step 2: Identify missing semicolon
The last RAISE NOTICE 'Other' lacks a semicolon.
Final Answer:
Missing semicolon after the last RAISE NOTICE statement. -> Option B
Quick Check:
Statements must end with semicolons [OK]

Quick Trick: Every statement ends with semicolon in PL/pgSQL [OK]

Common Mistakes:

Using ELSEIF instead of ELSIF
Forgetting semicolons after statements
Misdeclaring variables

Master "PL/pgSQL Fundamentals" in PostgreSQL

9 interactive learning modes - each teaches the same concept differently

Learn Why Deep Visual Try Challenge Project Recall Time

Identify the error in this PL/pgSQL snippet:

Step 1: Check syntax of RAISE NOTICE statements

Step 2: Identify missing semicolon

Final Answer:

Quick Check:

Want More Practice?