Multiple choice

When a 'Select' command is written inside a PL/SQL program, the ____ keyword must be included in it.

  1. where

  2. in

  3. group by

  4. into
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

All PL/SQL 'select' statements must contain the 'into' keyword. The 'into' keyword is used to copy the values returned by a select statement into variables. For example, the statement - 'select bookno, bookname, price into bkno, bkname,bkprice from books where title='Oracle''- will copy the values of bookno, bookname and price columns in the variables bkno, bkname and bkprice, respectively. The 'into' clause is not used when the 'select' statement is used at the SQL prompt.

Keep practicing — related questions