Home » SQL & PL/SQL » SQL & PL/SQL » Pseudo-column (Oracle)
Pseudo-column [message #300705] Sun, 17 February 2008 22:14 Go to next message
ttparavindh
Messages: 22
Registered: December 2006
Location: Bangalore,India
Junior Member

hi,what is pseudo-column in oracle?, any one can help me
Re: Pseudo-column [message #300706 is a reply to message #300705] Sun, 17 February 2008 22:17 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Google is your friend, but only when you use it.
Re: Pseudo-column [message #300707 is a reply to message #300705] Sun, 17 February 2008 22:23 Go to previous messageGo to next message
spmano1983
Messages: 269
Registered: September 2007
Senior Member
Hi,

It's like a column only. We can use in any tables.

Ex: rowid
rownum
level
user
sysdate
in sequence currval,nextval


Thanks
Mano
Re: Pseudo-column [message #300709 is a reply to message #300707] Sun, 17 February 2008 22:36 Go to previous messageGo to next message
ttparavindh
Messages: 22
Registered: December 2006
Location: Bangalore,India
Junior Member

Thanks
Re: Pseudo-column [message #300753 is a reply to message #300705] Mon, 18 February 2008 00:48 Go to previous messageGo to next message
Michel Cadot
Messages: 64117
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Database SQL Reference
Chapter 3 Pseudocolumns

Regards
Michel
Re: Pseudo-column [message #300786 is a reply to message #300707] Mon, 18 February 2008 02:29 Go to previous messageGo to next message
pablolee
Messages: 2834
Registered: May 2007
Location: Scotland
Senior Member
spmano1983 wrote on Mon, 18 February 2008 04:23
Hi,

It's like a column only. We can use in any tables.

Ex: rowid
rownum
level
user
sysdate
in sequence currval,nextval


Thanks
Mano

sysdate is not a pseudo column, it is a function.
Re: Pseudo-column [message #300789 is a reply to message #300786] Mon, 18 February 2008 02:32 Go to previous messageGo to next message
Michel Cadot
Messages: 64117
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
As well as USER.

Regards
Michel
Re: Pseudo-column [message #300790 is a reply to message #300789] Mon, 18 February 2008 02:36 Go to previous message
pablolee
Messages: 2834
Registered: May 2007
Location: Scotland
Senior Member
Didn't even see user in that list. Coffee time ./fa/450/0/
Previous Topic: urgent help required(recursive triggers)
Next Topic: gettint error while using case in sql statement
Goto Forum:
  


Current Time: Tue Dec 06 04:41:21 CST 2016

Total time taken to generate the page: 0.06833 seconds