GeekInterview.com
Series: Subject: Topic:
Question: 87 of 133

What are the more common pseudo-columns


Answer posted by Scott on 2005-05-25 18:43:29: SELECT rownum, rowid 
FROM sometable
Asked by: Interview Candidate | Asked on: Aug 24th, 2005
Showing Answers 1 - 8 of 8 Answers
Scott

Answered On : May 25th, 2005

SELECT rownum, rowid FROM sometable

  
Login to rate this answer.
PALLAVI

Answered On : Aug 24th, 2005

ROWNUM, ROWID, LEVEL

  
Login to rate this answer.
Venu.

Answered On : Nov 24th, 2005

PALLAVI Wrote: ROWNUM, ROWID, LEVELThe common pseudo coumns are Rowid,Rownum,level,nextval,curval..   

  
Login to rate this answer.
Venugopal Chowdary.M

Answered On : Dec 16th, 2005

The most commonly used psuedo columns are sysdate,rowid

  
Login to rate this answer.
na123

Answered On : Mar 24th, 2006

View all questions by na123   View all answers by na123

common pseudo-columns-Rownm,Rowid,Level,Currval,Nextval.

  
Login to rate this answer.
sweetytrivedi

Answered On : Jun 24th, 2008

View all answers by sweetytrivedi

Besides these, the other pseudo columns are: user,uid

  
Login to rate this answer.
laxman

Answered On : Oct 9th, 2011

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

  
Login to rate this answer.
Ankush Gupta

Answered On : Feb 10th, 2012

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

  
Login to rate this answer.

Give your answer:

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

Related Open Questions

Ads

Connect

twitter fb Linkedin GPlus RSS

Ads

Interview Question

 Ask Interview Question?

 

Latest Questions

Interview & Career Tips

Get invaluable Interview and Career Tips delivered directly to your inbox. Get your news alert set up today, Once you confirm your Email subscription, you will be able to download Job Inteview Questions Ebook . Please contact me if you there is any issue with the download.