Re: Testing if JVM is installed

From: JoeB <nomail_at_nomail.com>
Date: Sat, 2 Aug 2003 14:15:17 +0100
Message-ID: <FPOWa.3359$Kx1.44930@newsfep4-glfd.server.ntli.net>

"TimMcConechy" <tjm_at_runtime.dk> wrote in message news:7afae186.0308020433.7b8b116f_at_posting.google.com...
> Hi,
>
> Whats the most reliable test to check if Java is installed on an
> Oracle server with SQL. What I am actually looking for is the SQL i
> can use to get back the text shown when you login in SQL Plus:
>
> For example:
> JServer Release 9.2.0.1.0 - Production
>
> I noticed that: v$version does not contain this information.
>
> BR
> Tim

The following should return zero rows and work across all versions of the database:

select count(*) from all_objects where object_type like 'JAVA%';

HTH JoeB Received on Sat Aug 02 2003 - 08:15:17 CDT