Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Help Me With a Simple PL/SQL Request Please !!
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 - 11:21:33 CDT