|Small Urgent Help Neede in PL?SQL [message #375950]
||Mon, 15 December 2008 07:36
Registered: December 2008
Hi Frens |
I hav a small requirement but really stuck in it!
Has 2 tables with the following columns
i live in texas and work in AIG.
We shud look for tags_name in notes field of abc_y. If we encounter any tags_name in notes field they shud be removed and inserted in frmt field
Now the column frmt shud be updated to 'i texas and AIG'.
abc_y has 2 million rows and abc_z has 120 rows.
wrote the code sucessfuly but cannot bulk update it, which is really needed for me.
Plsssss help me.
I am havin some problm in FOR LOOP after FORALL in the folowing.
l_sql_strng VARCHAR2 (20000);
TYPE var_tab IS TABLE OF VARCHAR2 (20000)
INDEX BY BINARY_INTEGER;
BULK COLLECT INTO l_text_arry LIMIT 5000;
FORALL i IN l_text_arry.FIRST .. l_text_arry.LAST
FOR j IN (SELECT tags_name
l_text_arry(i) := REPLACE (l_text_arry(i), j.tags_name);
SET frmt = l_text_arry (i);
when others then
Thanks a million!!!
Please correct my code. thanks!!