dbms_parallel_execute -- /*+ROWID(dda)*/
775432May 26 2010 — edited May 28 2010Hi, can anyone explain me, please, what (dda) stands for, what table is it or alias in /*ROWID(dda)*/ hint.
All dbms_parallel_execute examples I saw on Internet use the same /*+ ROWID (dda)*/ without explanation what is (dda) is for;
Thanks;
DECLARE
l_sql_stmt VARCHAR2(32767);
BEGIN
l_sql_stmt := 'UPDATE /*+ ROWID (dda)*/ test_tab t
SET t.num_col = t.num_col + 10
WHERE rowid BETWEEN :start_id AND :end_id';
DBMS_PARALLEL_EXECUTE.run_task(task_name => 'test_task',
sql_stmt => l_sql_stmt,
language_flag => DBMS_SQL.NATIVE,
parallel_level => 10);
END;
/