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

This is not what I want, my script should 'act different on another version'.
I know how to check the version, but how make some kind of an 'if construction' ??

if the version is 7.3 I would do this:
select uername,password,created from dba_users; but if it was 8.1.7 I could do this:
select username,password,lock_date,expiry_date from dba_users;

Maybe someone already found a solution for this.....

Tom
t.breed_at_hccnet.nl

"Ikarus" <luciver_at_zone.at> schreef in bericht news:aXfa8.614220$5G5.4426216_at_news.chello.at...
> Or you can check the compatible Parameter from the v$parameters ?
>
>
Received on Tue Feb 12 2002 - 16:29:23 CST