{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}


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

{[ snackBarMessage ]}

Ask a homework question - tutors are online