<div>
<div class="content wysiwyg-content">
I have an oracle table for Documents with fileds DocNo , Revision, State , Plant 
&nbsp; Only some revisions &nbsp;for a given docno has the plant value &nbsp; 
&nbsp; &nbsp;sample data 
&nbsp; &nbsp;DocNo &nbsp;Revision &nbsp;State Plant 
&nbsp; &nbsp; Doc1 &nbsp; &nbsp; &nbsp; 1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1 &nbsp; &nbsp; &nbsp; 
&nbsp; &nbsp; Doc1 &nbsp; &nbsp; &nbsp; 2 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1 &nbsp; &nbsp; &nbsp; &nbsp; P1 
&nbsp; &nbsp; &nbsp;Doc1 &nbsp; &nbsp; &nbsp;3 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2 &nbsp; &nbsp; 
&nbsp; &nbsp; Doc2 &nbsp; &nbsp; &nbsp; 1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1 &nbsp; &nbsp; &nbsp; &nbsp; 
&nbsp; &nbsp; &nbsp;Doc2 &nbsp; &nbsp; &nbsp; 2 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;3 &nbsp; &nbsp; &nbsp; &nbsp;P2 
 
&nbsp; I need a view with following 
&nbsp; &nbsp;For rows where Plant value present &nbsp;return state as state * 10 
&nbsp; &nbsp;For rows with no plant value , look DocNo and return plant value &nbsp; from the row &nbsp;for same DocNo with plant value 
 
&nbsp; View should be like 
DocNo &nbsp;Revision &nbsp;State Plant 
&nbsp; &nbsp; Doc1 &nbsp; &nbsp; &nbsp; 1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; P1 
&nbsp; &nbsp; Doc1 &nbsp; &nbsp; &nbsp; 2 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;10 &nbsp; &nbsp; &nbsp; &nbsp; P1 
&nbsp; &nbsp; &nbsp;Doc1 &nbsp; &nbsp; &nbsp;3 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2 &nbsp; &nbsp; &nbsp; &nbsp; P1 
&nbsp; &nbsp; Doc2 &nbsp; &nbsp; &nbsp; 1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;P2 &nbsp; &nbsp; &nbsp; 
&nbsp; &nbsp; &nbsp;Doc2 &nbsp; &nbsp; &nbsp; 2 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;30 &nbsp; &nbsp; &nbsp; &nbsp;P2
</div>
</div>

I have an oracle table for Documents with fileds DocNo , Revision, State , Plant
  Only some revisions  for a given docno has the plant value  
   sample data 
   DocNo  Revision  State Plant
    Doc1       1            1      
    Doc1       2            1         P1
     Doc1      3             2    
    Doc2       1            1         
     Doc2       2            3        P2 

  I need a view with following
   For rows where Plant value present  return state as state * 10
   For rows with no plant value , look DocNo and return plant value   from the row  for same DocNo with plant value 

  View should be like 
DocNo  Revision  State Plant
    Doc1       1            1           P1
    Doc1       2            10         P1
     Doc1      3             2         P1 
    Doc2       1            1          P2       
     Doc2       2            30        P2

Oracle view to get a field value based on another row

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.