title: I want to covert rows from one table to columns to another table using Procedures(Pl/sql)
body: <pre><code>table A:
  
  col1
  _______________________
  jack 
  1200
  20
  peter
  2000
  10
  robert 
  300
  30
  </code></pre>
  
  <p>to </p>
  
  <pre><code>table B :
  
  name   sal   deptno
  -----------------------
  jack 1200 20
  peter 2000 10
  robert 300 30
  </code></pre>
  
  <p>here I want this by using procedure parameter. can you please help I tried with it but it is giving errors.</p>
  
  <pre><code>create procedure GetDatafromtable_A(V_1 in varchar2)
  as
  CURSOR rwdatacursor IS select Raw_Data  from table_a where rowid&lt;=3)
  T_record rwdatacursor%rowtype;
  begin
  open rwdatacursor;
  loop
  fetech rwdatacursor into T_record;
  exit when rwdatacursor%NOTFUND;
  insert into temp_process;
  end loop
  close rwdatacursor;
  end;
  </code></pre>
  
  <p>This is the codew I have tried but showing lot of errors</p>