title: Report showing the index column
body: <p>I have a question to generate a report, need it to take data from a SQL table and place the name of the table takes her ID, below the data that the query generates</p>
  
  <p>COD_CLIENTE NOME ENDERECO CPF</p>
  
  <pre><code>  2 Fulano               Av. Rio Branco       2837462890           
    3 Ciclano              Rua Zero             4625427282           
    4 Beltrano             Rua Doze             2634623637 
  </code></pre>
  
  <p>I created this procedure</p>
  
  <pre><code>create or replace PROCEDURE COLUNAS_TESTE AS 
  Cursor linha is
  Select cod_cliente, nome, endereco, cpf from clientes where rownum &lt; 4;
  
  rLin linha%rowtype;
  
  BEGIN
  Open linha;
  Loop
  
  Fetch linha into rLin;
  
  Exit when linha%notFound;
  
      dbms_output.put_line('Linha: '||rLin.cod_cliente||' Coluna: 2'||' Valor: '||rLin.Nome);
      dbms_output.put_line('Linha: '||rLin.cod_cliente||' Coluna: 3'||' Valor: '||rLin.Endereco);
      dbms_output.put_line('Linha: '||rLin.cod_cliente||' Coluna: 4'||' Valor: '||rLin.CPF);
  End loop;
  Close linha;
  END;
  </code></pre>
  
  <p>Generating this result</p>
  
  <pre><code>Linha: 2 Coluna: 2 Valor: Fulano
  Linha: 2 Coluna: 3 Valor: Av. Rio Branco
  Linha: 2 Coluna: 4 Valor: 2837462890
  Linha: 3 Coluna: 2 Valor: Ciclano
  Linha: 3 Coluna: 3 Valor: Rua Zero
  Linha: 3 Coluna: 4 Valor: 4625427282
  Linha: 4 Coluna: 2 Valor: Beltrano
  Linha: 4 Coluna: 3 Valor: Rua Doze
  Linha: 4 Coluna: 4 Valor: 2634623637
  </code></pre>
  
  <p>Line and value OK, he gets the code, but I need two reports, one in place of the column he put the field name, and another that put the column index, there did gambiarra to put the "fixed", but need it dynamically, I hope you managed to explain.</p>
  
  <p>Even managed to make a select to search this data, but could not relate it with my column, if someone can help and I have been able to explain the problem.</p>
  
  <pre><code> select COLUNAS.COLUMN_ID AS COLUNAS_ID ,COLUNAS.COLUMN_NAME AS COLUNAS_NOME
   from USER_TAB_COLUMNS COLUNAS
   where COLUNAS.TABLE_NAME = 'CLIENTES';
  </code></pre>