Re: Block question

From: pavan kumar <>
Date: Sat, 28 Feb 2015 08:52:58 +0000
Message-ID: <>

The searching block id, can be initial block or with in the range of blocks. - ThanksPavan Kumar N

      From: Paul Harrison <>  To: 'ORACLE-L' <>  Sent: Saturday, 28 February 2015 1:51 AM  Subject: Block question    

<!--#yiv3866692616 _filtered #yiv3866692616 {font-family:Calibri;panose-1:2 15 5 2 2 2 4 3 2 4;}#yiv3866692616 #yiv3866692616 p.yiv3866692616MsoNormal, #yiv3866692616 li.yiv3866692616MsoNormal, #yiv3866692616 div.yiv3866692616MsoNormal {margin:0in;margin-bottom:.0001pt;font-size:12.0pt;font-family:"Times New Roman", "serif";}#yiv3866692616 a:link, #yiv3866692616 span.yiv3866692616MsoHyperlink {color:blue;text-decoration:underline;}#yiv3866692616 a:visited, #yiv3866692616 span.yiv3866692616MsoHyperlinkFollowed {color:purple;text-decoration:underline;}#yiv3866692616 span.yiv3866692616EmailStyle17 {font-family:"Arial", "sans-serif";color:windowtext;}#yiv3866692616 .yiv3866692616MsoChpDefault {font-family:"Calibri", "sans-serif";} _filtered #yiv3866692616 {margin:1.0in 1.0in 1.0in 1.0in;}#yiv3866692616 div.yiv3866692616WordSection1 {}-->Hi Team,    I came upon the below on the internet." ( &block_value BETWEEN block_id AND ( block_id + blocks ) )"    <-- I don't understand how this comes into the equation.  Shouldn't it just be &block_value = <value> ?        List an Object and Object Type via a Given File and Block ID.  ---- List an Object and Object Type via a Given File and Block ID.-- SET PAUSE ONSET PAUSE 'Press Return to Continue'SET PAGESIZE 60SET LINESIZE 300 COLUMN segment_name FORMAT A24COLUMN segment_type FORMAT A24 SELECT segment_name, segment_type, block_id, blocks   FROM   dba_extents   WHERE          file_id = &file_no   AND          ( &block_value BETWEEN block_id AND ( block_id + blocks ) )/      Thanks,Paul   

Received on Sat Feb 28 2015 - 09:52:58 CET

Original text of this message