Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.
Fetching data in embedded SQL is done using the SELECT statement. There are two cases:
The SELECT statement returns no rows or returns exactly one row.
The SELECT statement returns multiple rows.
Fetching one row
Fetching multiple rows