You can use v$version.
--
Terry Dykstra
Canadian Forest Oil Ltd.
"Jack Addington" <jaddington_at_shaw.ca> wrote in message
news:5Ew5f.240781$tl2.182354_at_pd7tw3no...
> I have a storedproc that drops/creates tables using dynamic sql. I also
> have clients in both 10g and 9i and for those in 10g I wanted to include
the
> purge command as part of the drop as there is no need for these tables to
> clutter the recycle bin.
>
> 1) I'm assuming there is some sort of session variable that tells me the
> major server version?
>
> 2) Is this a bad approach? It seems ok given its dynamic sql...
>
> thx
>
> Jack
>
>
Received on Wed Oct 19 2005 - 14:12:51 CDT
