title: table in database rows
body: <p>I have a table <strong>People</strong>, having <em>people_id,people_name,people_lastname</em>. I am facing difficulties creating a pl/sql function to display all the rows of that table. 
  I have done this much so far </p>
  
  <pre><code>create or replace function PeopleTable(
  people_id in int,student_name in varchar (255),student_lastname in varchar (255))
    return table_People
    as cursor curs
    is  select people_id,people_name,student_lastname from People 
        var table_People:=table_res();
        begin open curs ;
       loop 
          fetch curs 
           bulk collect into var limit 100;
            exit when curs%notfound;
    end loop; 
  close curs;
  </code></pre>