Re: Help Me With a Simple PL/SQL Request Please !!

    Depending on what you want to do with the rows, you could also use PL/SQL to pop them into a global temporary table which would remain available for further processing by your session.

    You didn't ask about this but from a database design point of view what will you do if the contact is affiliated with more than one organization, has more than one address or has more than one email address?

Van

"wayne" <no_at_email.please.com> wrote in message news:9a7kid$9ea_at_freepress.concentric.net...
>
> Tried this?:
>
> select * from member_contact where (last_name='SMITH');
>
> if the records are stored in mixed case try this:
>
> select * from member_contact where (upper(last_name)='SMITH');
>
> the first statement is more efficient that the second because the first
 can
> take advantage of an index, the second cannot, but more on that later...
>
> "Charlotte Hurley" <firas3_16_at_yahoo.com> wrote in message
> news:kitdcts6cqpvqael26jasdhdjnnc0f4c2b_at_4ax.com...
> > Hello Everyone,
> >
> > Has anyone developed a PL/SQL procedure/function used to
> > return a search result from a table ?. Consider the following table :
> >
> > Table : MEMBER_CONTACT
> >
> > Fields: CONTACT_ID
> > ORGANIZATION_ID
> > FIRST_NAME
> > LAST_NAME
> > TITLE
> > EMAIL_ADDRESS
> > CITY
> > STATE
> > COUNTRY
> >
> >
> > I would like to make a procedure/function that would take in
> > the last_name as an input parameter, and return all the users in this
> > table matching the surname. Does anyone know what is the most
> > efficient way to do this ? I can only return one record as a result so
> > far, but does anyone know how to make the procedure return multiple
> > records for possible matches based on the surname ? (in an efficient
> > way). Any help would be greatly appreciated, thank you in advance.
> >
> >
> > Kind Regards,
> > Charlotte Hurley,
> > firas3_16_at_yahoo.com
>
>
Received on Sun Apr 01 2001 - 12:07:03 CDT