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 Plus

 Print  |  
Question:  Explian the 18 character long ROWID? How it gets constructed? How we will identify each part of ROWID?



June 06, 2009 08:58:36 #2
 imtiazali   Member Since: June 2009    Total Comments: 4 

RE: Explian the 18 character long ROWID? How it gets constructed? How we will identify each part of ROWID?
 
Rowid and Rownum are psuedocolumns for every table Oracle provides unique rowid, rownum.
Rowid are in alphanumeric, rowid are 18 character, for every rowid last 3 character will be changed.
     

 

Back To Question