When you use SELECT in a PL/SQL block, it’s important to make sure that exactly one row will always be returned by your query. If more than one row is returned, the TOO_MANY_ROWS exception occurs.

ODBC Select With Row and Column bind This is an ODBC SELECT sample with Row and Column wise Bind. Then each case retrieving values by using SQLFetchScroll and SQLExtendedFetch. Thou the code is mostly ...

Maybe this is a strange question, but is there a way to add a single row (or several) to the return set of a SELECT statement?Example:I want to populate a drop down list with SELECT EmpID ...