Fetching data

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.


Fetching one row
Fetching multiple rows