DECLARE
ANS T_ECMC_USERS%ROWTYPE;
START_TIME NUMBER;
BEGIN
dbms_output.enable;
START_TIME := dbms_utility.get_time();
FOR i in 1 .. 1000 LOOP
BEGIN
EXECUTE IMMEDIATE
'SELECT * FROM T_ECMC_USERS WHERE USER_ID = ' || i
INTO ANS;
EXCEPTION
WHEN NO_DATA_FOUND THEN NULL;
END;
END LOOP;
dbms_output.put_line(dbms_utility.get_time() - START_TIME);
END;
1655