http://www.oracleobserver.com/?q=node/28 seems to have an unnecessary
use of dual, or am I missing something?

It seems to work fine for me without it.

jg
--
@home.com is bogus.
http://www.shapirolab.net/PerpetualCollisions/

joel garry wrote,on my timestamp of 26/01/2011 11:42 AM:


Weird. Only thing I can think of is if v$instance is available and dual isn't,
like in a startup? Nup, even then it wouldn't work: it's a cartesian product...

On Jan 26, 12:42*am, joel garry <joel-ga... (AT) home (DOT) com> wrote:
I think he's confused

Plus that's not a script, it's a query </pedant>

-g

Joel:

# http://www.oracleobserver.com/?q=node/28seems to have an unnecessary
use of dual, or am I missing something?

A new hire to a certain unnamed consulting group?

Joel:

Hey a tied vote at 50 percent each with a grand total of 2 votes in so
far ...

On Jan 28, 12:31*am, John Hurley <hurleyjo... (AT) yahoo (DOT) com> wrote:
That link now dsisplays "page not found". I guess he's havinga re-
think

On Jan 27, 8:29*pm, John Hurley <hurleyjo... (AT) yahoo (DOT) com> wrote:
That's my vote. Since PUBLIC access to UTL_TCP is a 'critical'
security policy finding, and access to V$INSTANCE requires additional
privileges, why not do it the simple way that anyone with CREATE
SESSION can use?
create user test identified by test;
grant create session to test;
connect test/test@alias
select sys_context('userenv','server_host') host,
sys_context('userenv','instance_name') instance_name,
sys_context('userenv','ip_address') ip_address from dual;
HOST INSTANCE_NAME
IP_ADDRESS
------------------------------ ------------------------------
----------------
laptop-1005596 orcl
10.10.10.10

I know, it's a lot more typing!

On Jan 28, 1:29*am, John Hurley <hurleyjo... (AT) yahoo (DOT) com> wrote:
Probably a sloppy cut&paste from a 'standard' query to get the host-
name from dual, adding the extra info from v$instance.

Don't think so:
http://oaktable.net/users/gpmilliken

--
J

On Jan 28, 12:26*pm, gazzag <gar... (AT) jamms (DOT) org> wrote:
The link provided by Joel works OK, but you corrupted it in your first
reply..

--
J

The Boss:

# Probably a sloppy cut&paste from a 'standard' query to get the host-
name from dual, adding the extra info from v$instance.

.... Don't think so: http://oaktable.net/users/gpmilliken

Maybe someone should submit this is as a question to the Oakies ...
there sure are a lot of them lately.

I have started my own relatively exclusive group the GROUNDHOGs
( GRumpy Old UNderachieving Dbas HOokup Group ) ... wouldn't a
groundhog chew on the leg of an oak table?