Poondru

• Jan 3rd, 2006

 

Yes...You are right.Some more examples of psedo columns are

rowid

versions_xid

versions_operation

versions_startscn

versions_endscn

sysdate

systimestamp

rownum

ora_rowscn

object_value

level

user

Rohan Deshpande

• Jan 29th, 2007

 

NEXTVAL and CURRVAL are also pseudo column...

LRANI

 Profile Answers by LRANI 

• Aug 2nd, 2007

 

pseudocolumn behaves like an column of a table but actually it is not a column of the table. User can not insert/update/delete this column. Following are the
pseudocolumns are available in oracle10g:

Hierarchical, rowid, rownum, sequence,xmldata,object_id,object_value,column value, version query, ora_rowscn.

patilpravin_1981

 Profile Answers by patilpravin_1981 

• Jan 30th, 2008

 

Pseudo columns is not actula column in the table. it behaves like table column
we can retivesv values of pseduo column but can not insert,update or delete value in that.
has two data type 1. rowid  2. urowid
row id uniqely identify row in database

EXM : select rowid,last_name form employees

subhu

• Sep 26th, 2011

 

A pseudo column is an item of data which does not belong in any particular table but which can be treated as if it did.

D.Elumalai

• Oct 12th, 2011

 

1.sysdate

2.systimestamp

3.user

4.uid

5.rownum

6.rowid

7.nextval

8.currval

KARTHIK

• Dec 11th, 2011

 

1) Pseudo columns behave like a table column, but it is not actually stored in a table.

2) Upon pseudo columns only select statements can be implemented. Insert, delete,update cannot be implemented.

Currval, (can be used in set clause of an update, values clause of an insert)

Nextval, (can be used in set clause of an update, values clause of an insert)

Level, Rowid, Rownum.

qptopm

 Profile Answers by qptopm 

• Nov 7th, 2016

 

Pseudocolumns are symbolic aliases for actual columns, that have special properties,

qptopm

 Profile Answers by qptopm 

• Nov 7th, 2016

 

It behaves like a table column, but is not actually stored in the table.

Amol Kulkarni

• Dec 3rd, 2016

 

Pseudo columns are used to pass additional information on a row. A pseudo column is not actually part of a row like any other columns. but exists due to the row property, they cannot be updated or modified but are used only for retrieval purpose, user can access the pseudo columns as if they are normal columns in the select statement.