Execute SELECT statements

You can execute a SELECT statement in the following two ways:

• If the SELECT statement returns only one row, use PREPARE and EXECUTE INTO. This type of SELECT is often called a singleton SELECT.
• If the SELECT statement returns more than one row, you must use cursor-management statements.