NEW INTERVIEW QUESTIONS.COM
ORACLE INTERVIEW QUESTIONS
PL-SQL INTERVIEW QUESTIONS DETAILS
NewInterviewQuestions.com - Home for World's Largest Interview Questions Website.
A D V E R T I S E M E N T
||Explian rowid,rownum?what are the psoducolumns we have?
ROWID - Hexa decimal number each and every row having unique.Used in searching.
ROWNUM - It is a integer number also unique for sorting Normally TOP N Analysys.
Other Psudo Column are
NEXTVAL,CURRVAL Of sequence are some exampls
psudo columns are default columns provided by oracle
Answered By: jayachandra Date: 4/24/2007
Rowid is the physical address of the record/row, its in hexadecimal format. rownum is the number given to a row which is fetched by a select statement. Examples for Psudo columns are ROWNUM,SYSDATE,ROWID,LEVEL etc
Answered By: Nagaraja Musturi Date: 8/7/2007
User, sysdate, rownum, rowid
Answered By: Dhanajay Date: 4/3/2008
If you have the better answer, than send it to us. We will display your answer after the approval.
Rate the above answer. Help us to know about the answer.
Please Note: We keep on updating better answers to this site. Subscribe to our newsletter to get notified when better answer is posted.
|Notify me when better answer is posted!