Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

dbms_parallel_execute -- /*+ROWID(dda)*/

775432May 26 2010 — edited May 28 2010
Hi, 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;
/
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 25 2010
Added on May 26 2010
18 comments
5,457 views