PL_SQL_Cursor What are Cursors? A cursor is a temporary work area created in the system memory when a SQL statement is executed. A cursor contains information on a select statement and the rows of ...

In PL/SQL, you can refer to the most recent implicit cursor as the SQL cursor, which always has attributes such as %FOUND, %ISOPEN, %NOTFOUND, and %ROWCOUNT. The SQL cursor has additional attributes, ...

I know I could do this with a PL/SQL cursor to iterate over the list of existing agent_ids but I was wondering I could do this with pure SQL using a combination of DISTINCT and SELECT INTO.