10 Replies Latest reply: Dec 30, 2012 12:31 PM by 982158 RSS

    Display All records of my DB  in a table

    982158
      Hi All :)
      i want to display all the records of my database in a table with scrolling
      example if i have 3records in my DB so a table must have 3records too !!!
      this is my code :



      DECLARE
           Cursor cur IS
                SELECT numb_ph AS phone,
                     name_emp AS name
                FROM emp
           

                

      BEGIN
      GO_BLOCK('emp');
      FIRST_RECORD;
           FOR s IN cur LOOP
           :emp.numb_ph := s.phone;
           :emp.name_emp := s.name;
           
                NEXT_RECORD;     
           END LOOP;
      FIRST_RECORD;
      END;




      but the problem 's all records of my DB are display in one record (to view another record i use the scrolling ..
      thnx :)