This discussion is archived
10 Replies Latest reply: Dec 30, 2012 10:31 AM by 982158 RSS

Display All records of my DB  in a table

982158 Newbie
Currently Being Moderated
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 :)

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points