
December 1st, 2003, 03:48 PM
|
|
Junior Member
|
|
Join Date: Dec 2003
Posts: 5
Time spent in forums: < 1 sec
Reputation Power: 0
|
|
pl/sql
guys , am getting error on the following pl/sql ..pls help...not sure if am on the right track?
*************
Declare
Type Emp_Table Is Table Of Emp%RowType Index By Binary_Integer;
Emp_T Emp_Table;
Begin
Select * Bulk Collect Into Emp_T
From Emp;
For I In 1..Emp_T.Count Loop
If Emp_T(I).ename like '%K%' Then
dbms_output.put_line(Emp_T(1).ename);
End If;
End loop;
End;
************
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.
Last edited by vimal123 : December 1st, 2003 at 04:51 PM.
|