Statistics
| Revision:

gvsig-oracle / org.gvsig.oracle / trunk / org.gvsig.oracle / org.gvsig.oracle.provider / src / test / resources / org / gvsig / oracle / dal / operations / sql / calculateEnvelope.sql @ 916

History | View | Annotate | Download (336 Bytes)

1 

    		
  

  

    
      2
    
    
      

    		
  

  

    
      3
    
    
      

    		
  

  

    
      4
    
    
      
-- Count SQL


    		
  

  

    
      5
    
    
      
--SELECT NVL2((SDO_AGGR_MBR("Geometry")),(SDO_AGGR_MBR("Geometry")).Get_WKB(),NULL) 


    		
  

  

    
      6
    
    
      
--FROM "public"."test" 


    		
  

  

    
      7
    
    
      
--WHERE ( ("Geometry") IS NOT NULL );


    		
  

  

    
      8
    
    
      

    		
  

  

    
      9
    
    
      
SELECT NVL2((SDO_AGGR_MBR("P1"."TEST"."Geometry")),(SDO_AGGR_MBR("P1"."TEST"."Geometry")).Get_WKB(),NULL) 


    		
  

  

    
      10
    
    
      
FROM "P1"."TEST" 


    		
  

  

    
      11
    
    
      
WHERE ( ("P1"."TEST"."Geometry") IS NOT NULL );