Multiple choice technology databases

What is the syntax of select .... into statement

  1. SELECT row_name INTO variable_name FROM table_name [WHERE condition];

  2. SELECT column_name INTO variable_name FROM table_name [WHERE condition];

  3. SELECT column_name INTO variable_name FROM table_name [WHEN condition];

  4. SELECT table_name INTO variable_name FROM table_name [WHERE condition];
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

The SELECT INTO syntax in PL/SQL requires specifying the column name first, followed by the INTO keyword, then the variable name, then FROM, and optionally a WHERE clause. Option B correctly shows this structure with column_name as the source and variable_name as the destination.

Keep practicing — related questions