Fetching data

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


SELECT statements that return at most one row
Using cursors in embedded SQL
Fetching more than one row at a time