Re: simple problem

From: Jerome Vitalis <vitalismanN05P4M_at_gmail.com.invalid>
Date: 15 Oct 2007 18:28:52 GMT
Message-ID: <4713b164$0$31142$79c14f64@nan-newsreader-07.noos.net>

On Mon, 15 Oct 2007 16:03:15 +0000, abdoul85 wrote:

> hello
> I'd like to do sth like this:
>
> declare
> a varchar(100);
> begin
> select version into a from v$instance; if (a like '10%') then
> @ver10.sql
> else
> @oldver.sql
> end if;
> end;
>
> how to write something like that in PL/SQL ?

It should work. Post the error you get.

(And if you intend to install 11g, you'll have to update your test condition.) Received on Mon Oct 15 2007 - 13:28:52 CDT