select something, if it returns only 1 row then update a field on that row, if it returns more than one row then insert these rows into another table, including the first one Now the thing is, what's ...
Oracle’s PL/SQL language has two basic mechanisms for getting data from the database: SELECT and cursors. SELECT is designed to return a single row into local variables; cursors give you the ability ...