1Z0-149: Oracle Database Program with PL/SQLDemo

For a dynamic SELECT that returns one row, EXECUTE IMMEDIATE requires an INTO clause to receive the selected columns and a USING clause for input bind values. A %ROWTYPE record is valid as the INTO target for SELECT *. Both valid blocks bind the value 1 to the sole placeholder and fetch the resulting row into rec, so they return the same record.