Re: sqlplus question

Just to avoid any confusion:
USER is not a sqlplus variable , it's a SQL pseudo-column. amongst the others are
sysdate
and userenv
the userenv has various options

'sessionid'
'terminal'
'language'

Check out the docs and/or technet.oracle.com for more detail

Hth,

--
Sybrand Bakker, Oracle DBA
<vk02720_at_my-deja.com> wrote in message news:7u5g4s$87t$1_at_nnrp1.deja.com...
> What variables are available globally in a sqlplus session ?
> For example :
> select USER from dual;
> would get the variable USER
> What other similar variables can be 'selected from dual' ?
>
> Thanks.
>
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Thu Oct 14 1999 - 16:55:01 CDT