December 29th, 2012, 09:21 PM
Oracle forms:how to Display All records of my DB in a table
Hi All ,
i use oracle forms 10g ..
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:
but the problem 's all records of my DB are display in one record (to view another record i use the scrolling ..
Cursor cur IS SELECT numb_ph AS phone, name_emp AS name FROM emp
FOR s IN cur LOOP
:emp.numb_ph := s.phone;
:emp.name_emp := s.name;