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?



March 03, 2009 04:36:37 #1
 sharmasl   Member Since: March 2009    Total Comments: 10 

RE: Explian the 18 character long ROWID? How it gets constructed? How we will identify each part of ROWID?
 
IN 18 Character Long ROWID constructed as-

1 to 6 character are database object no.
7 to 9 character are file no.
10 to 15 character are block no.
16 to 18 character are rowno.

like this 18 character of rowid are constructed.....
     

 

Back To Question