What are the more common pseudo-columns


Answer posted by Scott on 2005-05-25 18:43:29: SELECT rownum, rowid 
FROM sometable
  • Interview Candidate
  • 14
  • 4459

Showing Answers 1 - 14 of 14 Answers

Scott

  • May 25th, 2005
 

SELECT rownum, rowid 
FROM sometable

  Was this answer useful?  Yes

PALLAVI

  • Aug 24th, 2005
 

ROWNUM, ROWID, LEVEL

  Was this answer useful?  Yes

Venu.

  • Nov 24th, 2005
 

PALLAVI Wrote: ROWNUM, ROWID, LEVEL

The common pseudo coumns are Rowid,Rownum,level,nextval,curval..

 

 

 


  Was this answer useful?  Yes

Venugopal Chowdary.M

  • Dec 16th, 2005
 

The most commonly used psuedo columns are sysdate,rowid

  Was this answer useful?  Yes

laxman

  • Oct 9th, 2011
 

pseudocolumns are uid,user,sysdate,rownum,rowid,level,rowscn

  Was this answer useful?  Yes

Ankush Gupta

  • Feb 10th, 2012
 

Common Pseudo columns are CURRVAL,NEXTVAL,ROWID,ROWNUM,SYSDATE etc.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions