Data fetching

Fetching data in embedded SQL is done using the SELECT statement. There are two cases:

  1. The SELECT statement returns no rows or returns exactly one row.

  2. The SELECT statement returns multiple rows.


Single row fetching
Fetching multiple rows