Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: How are Pseudo Columns utilised ?

Re: How are Pseudo Columns utilised ?

From: <tlondon_at_my-dejanews.com>
Date: Fri, 23 Apr 1999 12:41:38 GMT
Message-ID: <7fppq2$n30$1@nnrp1.dejanews.com>


In article <r6UT2.4$vW3.28_at_news.syd.ip.net.au>,   "François Selvan" <fselvan_at_ecg.com.au> wrote:
> I have a question, Basically how do Pseudo Columns work, any suggestions are
> welcome.
>
> Francois Selvan
>
>

  Which one or ones do you have in mind, they all work differently for instance sysdate makes a call to the o/s unless fixed_date is set to true, whereas rownum is assigned as the rows come from the rowsources during the execution of a query, user is retreived from the session state information is the PGA

Tim L

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Fri Apr 23 1999 - 07:41:38 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US