Re: simple problem

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 ?
>

Looks good - what did you actually try? And it actually is PL/SQL.

And a question: the @ver10 thing is SQL*Plus - not PL/SQL; why do you want this in PL/SQL when it will not work?

-- 
Regards,
Frank van Bortel

Top-posting is one way to shut me up...