GeekInterview.com
  I am new, Sign me up!
 
GeekInterview.com  >  Interview Questions  >  Oracle  >  SQL
Go To First  |  Previous Question  |  Next Question 
 SQL  |  Question 20 of 171    Print  
What is a pseudo column. Give some examples?
It is a column that is not an actual column in the table.
eg USER, UID, SYSDATE, ROWNUM, ROWID, NULL, AND LEVEL.



  
Total Answers and Comments: 4 Last Update: January 30, 2008   
  
 Sponsored Links

 
 Best Rated Answer
—

No best answer available. Please pick the good answer available or submit your answer.
January 03, 2006 17:22:05   #1  
Poondru        
RE: What is a pseudo column. Give some examples?...

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

    •  
    Is this answer useful? Yes | No
    January 29, 2007 04:09:00   #2  
    Rohan Deshpande        
    RE: What is a pseudo column. Give some examples?...
    NEXTVAL and CURRVAL are also pseudo column...
     
    Is this answer useful? Yes | No
    August 02, 2007 07:23:34   #3  
    LRANI Member Since: July 2007   Contribution: 6    
    RE: What is a pseudo column. Give some examples?...
    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.
     
    Is this answer useful? Yes | No
    January 30, 2008 02:56:28   #4  
    patilpravin_1981 Member Since: December 2007   Contribution: 29    
    RE: What is a pseudo column. Give some examples?
    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

     
    Is this answer useful? Yes | No


     
    Go To Top


     Sponsored Links

     
    About Us -  Privacy Policy -  Terms and Conditions -  Contact -  Ask Question -  Propose Category -  Site Updates 

    Copyright © 2005 - 2009 GeekInterview.com. All Rights Reserved

    Page copy protected against web site content infringement by Copyscape