Hello All,
I am new to PL/SQL and I need help in writing a stored procedure. Here is my requirement
1. I should be able to fetch all rows from a single column (user_id) from table_1 and store them in an array variable say 'useridarray'.
2. I have to iterate 'useridarray' (for every user_id) and fetch it's related properties which are stored in table_2, table_3 (like first_name, last_name, email_address etc;.) etc;. and insert them into respective columns of table_1.
Request your help! Thank you very much in advance.
Regards,
Santhosh