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

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 - 14:40:39 CST