Thread: pl/sql

    #1
  1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Dec 2003
    Posts
    5
    Rep Power
    0

    Angry 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 05:51 PM.

IMN logo majestic logo threadwatch logo seochat tools logo