guys i have table emp( empno(pk), ename, job, sal) how can i declare a pl/sql table of employee name type, populate the pl/sql with all employee information , & then loop thro pl/sql table to find out whose name has letter k as middle character.
thanks
makr