Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Connection info in SQLPlus?
> Is it possible to get the service I'm connected to in SQL*Plus?
> When I connect like this:
>
> connect scott/tiger_at_my_db
>
> I can get the name of the current user 'scott' using
>
> show user
>
> But how can I get 'my_db'?
select name from v$database;
fdp