This called correlated update you can find examples below

UPDATE TABLE(<SELECT STATEMENT>) <alias1>
SET <column_1> = (
  SELECT <column_1>
  FROM <table_2> <alias2>
  WHERE <alias2.table_name> = <alias1.table_name>);

in you sample :

UPDATE table1 t1
   SET (name, desc) = (SELECT t2.name, t2.desc
                         FROM table2 t2
                        WHERE t1.id = t2.id)
 WHERE EXISTS (
    SELECT 1
      FROM table2 t2
     WHERE t1.id = t2.id )

alternative way you can do this

UPDATE (SELECT t1.id, 
               t1.name name1,
               t1.desc desc1,
               t2.name name2,
               t2.desc desc2
          FROM table1 t1,
               table2 t2
         WHERE t1.id = t2.id)
   SET name1 = name2,
       desc1 = desc2

and now the final example is

UPDATE Table1 T1 SET
T1.name = (SELECT T2.name FROM Table2 T2 WHERE T2.id = T1.id),
T1.desc = (SELECT T2.desc FROM Table2 T2 WHERE T2.id = T1.id)
WHERE T1.id IN (SELECT T2.id FROM Table2 T2 WHERE T2.id = T1.id);

The only way to achieve this is trying to declare that cursor in the package level then you can use it in any procedure or function in that package and the logic behind that is any cursor delcared in any function or procedure the scope for this cursor is only in that function below you can find sample example :

package body my_pkg is

   cursor test_cur is select * from table;

   procedure proc1 is 
   begin
      open test_cur;
      ...
      close test_cur;
   end proc1;

   procedure proc2 is 
   begin
      open test_cur;
      ...
      close test_cur;
   end proc2;
end;

Note: keep in mind in that example below if you open declared cursor in procedure 1 and you didn’t close it if you trying to open the same cursor in the procedure 2 you will get an exception raising

Basically VARRAY is varying array type that is typically used when the number of instances to be stored is small that means if we have one customer and this customer have number of phone numbers in our case if we know exact how many phone number he has so we will use VARRAY otherwise we will go for using nested tables.
You can use VARRAY data type for:

1. A column in a relational table
2. A PL/SQL variable
3. A PL/SQL parameter of procedure or function
4. A PL/SQL function return type
5. A data attribute of an object type

Now We can use VARRAY for a fixed-size array

declare
   type array_t is varray(3) of varchar2(10);
   array array_t := array_t('Matt', 'Joanne', 'Robert');
begin
   for i in 1..array.count loop
       dbms_output.put_line(array(i));
   end loop;
end;

Or TABLE for an unbounded array like:

type array_t is table of varchar2(10);

for clarification we submit question and it’s answer to help others, please if you have any addition don’t hesitate to share with others here.