SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Procedure/Function

639485Nov 30 2009 — edited Nov 30 2009

Hi All,

I have a table and it contains fields like
FIRST_NAME,LAST_NAME,SAL,DEPTNO.

 FIRST_NAME    LAST_NAME    SAL     DEPTNO
------------------------------------------
Thomas        Mathew         900   90
MAthew        robinson      980    80
Thomas        Marteen       890    80
Mathew        Thomas        780    45
...
...
[/code]
requirement is , I want to "search name"
if I gave Search_Name="Thomas" it should display Thomas related records.
Search_Name="Mathew" it should display Mathew related fields.

Please let me know how to write a Procedure/Function for this req.

Thanks in Adv.

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 28 2009

Added on Nov 30 2009

4 comments

389 views