GeekInterview.com
   Home |  Tech FAQ  |   Interview Questions |  Placement Papers |  Tech Articles |  Learn |  Freelance Projects |  Online Testing |  Geeks Talk |  Job Postings |  Knowledge Base | Site Search |  Add/Ask Question

GeekInterview.com  >  Interview Questions  >  Oracle  >  SQL
Go To First  |  Previous Question  |  Next Question 
 SQL  |  Question 20 of 170    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  |   Site Map  |   Add Question  |   Propose Category  |   RSS Feeds  |   Articles Sitemap  |   Site Updates  |   Add Resource

    Copyright © 2005 - 2008 GeekInterview.com. All Rights Reserved
    Page copy protected against web site content infringement by Copyscape