TooManyRows

TooManyRows - the results returned by a query. */ declare...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
Sheet1 Page 1 /* In the PL/SQL environment, a SELECT statement cannot retrieve more than one row without raising the TOO_MANY_ROWS exception. To retrieve an arbitrary number of rows from a query, you can use a cursor, which you can think of as a window on
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: the results returned by a query. */ declare Emp_Rec Emp%ROWTYPE begin dbms_output.enable select * into Emp_Rec from Emp exception when TOO_MANY_ROWS then dbms_output.put_line('TOO_MANY_ROWS raised - use a cursor') when OTHERS then NULL end /...
View Full Document

This note was uploaded on 07/15/2011 for the course ECO 2023 taught by Professor Mr.raza during the Summer '10 term at FAU.

Ask a homework question - tutors are online