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 ?

Oracle is not a Microsoft product.

What you wrote is roughly inequivalent to "I'd like to do something like something I can not code." We have no idea what it is you are trying to do. Try writing out the business requirement in English.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org