Re: How to convert this SQL-Statement to PL/SQL?

From: Martin Jesterhoudt <martinj_at_worldonline.nl>
Date: 1997/08/04
Message-ID: <33e63089.1863449@news.worldonline.nl>#1/1

On Sun, 03 Aug 1997 22:49:29 +0200, Ansgar Scherp <Ansgar.Scherp_at_Artis.Uni-Oldenburg.DE> wrote:

> SELECT *
> FROM Customer
> WHERE name = "..." OR name = "..." ...
>with an undefinded number of ' name = "..." '.
>
>How can I do this in PL/SQL?

Simple:

declare
  r_customer customer%type;
begin

  select	*
  into	r_customer
  from      customer
  where	name in ('FIRST','SECOND', 'ETCETERA...');

end;

I don't know where your undefined number of 'name="..."' comes from.

---

• Martin Jesterhoudt ---
• martinj(replace this by @)worldonline.nl ---

  ---

Received on Mon Aug 04 1997 - 00:00:00 CDT