Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: sqlplus question
It is interesting, however, that in the documentation (at least for 7.3.4),
in the section of the Sql Reference where it describes pseudocolumns 'USER'
is not listed, nor is SYSDATE. Others such as NEXTVAL, CURVAL, ROWID and
ROWNUM are. That doesn't make sense.
Sybrand Bakker wrote:
>
> 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 Fri Oct 15 1999 - 07:01:40 CDT