Re: How to verify the actual connection in sqlplus

Thank you Mark,
  for me the decision would be
  select HOST_NAME || ':' || INSTANCE_NAME || '$' || USER IAM from v$instance;   

  but how to pack it in a view for : select * from W;

mark.powell_at_eds.com (Mark D Powell) wrote in message news:<178d2795.0111201248.30ca1c37_at_posting.google.com>...
> gle_at_rts.co.at (Erhard Glueck) wrote in message news:<3653c318.0111200503.3aabcacf_at_posting.google.com>...
> > in sqlplus I need to verify the connection string used for the actual
> > connection.
> > Because I have more sessions over days open, I want to be certain, to
> > which database I speak, and this is only possible to be remembered
> > belonging the whole connection string.
>
> Why not just query Oracle for the database name or instance name?
>
> select * from v$database;
> select * from v$instance;
>
> -- Mark D Powell --
Received on Wed Nov 21 2001 - 12:03:11 CST