Re: Oracle SQL 7.3, 8.0,8.1,8.1.7,9......

select * from v$version;

"Tom Breed" <t.breed_at_hccnet.nl> wrote in message news:a4buc1$sc0$1_at_news.hccnet.nl...
> I've got a lot of sqlscripts and a tool to start these scripts, using
> SQL*Plus. What I need is a solution for the problem that a script written
> for 8.1.7 sometimes will not run on a 7.3 database. I want a solution like
> this:
> I start my script and in the script will be checked what version this
> database is and will run the correct sql commands.....
> Anybody konow how to do that, or me someone already did ??
>
>
> start abc.sql
>
>
> abc.sql:
>
> select ... from v$version
>
> if 7.3 ---> select this and that from dba_users
>
> if 8.1.7 ----> select this and that but also INITIAL_RSRC_CONSUMER_GROUP
> from dba_users
>
> if 9 ..........
>
> Any to achieve something like this ??
>
>
> Thanks,
>
> Tom.
> t.breed_at_hccnet.nl
>
>
>
>
Received on Tue Feb 12 2002 - 15:04:17 CST