Statistics
| Revision:

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

History | View | Annotate | Download (531 Bytes)

1 

    		
  

  

    
      2
    
    
      
-- fetchFeatureProviderByReference SQL


    		
  

  

    
      3
    
    
      
SELECT 


    		
  

  

    
      4
    
    
      
    "P1"."TEST"."ID", "P1"."TEST"."Byte", "P1"."TEST"."Bool1", "P1"."TEST"."Long", 


    		
  

  

    
      5
    
    
      
    "P1"."TEST"."Timestamp", "P1"."TEST"."Date", "P1"."TEST"."Time", 


    		
  

  

    
      6
    
    
      
    "P1"."TEST"."Bool2", "P1"."TEST"."String", "P1"."TEST"."Bool3", "P1"."TEST"."Double", 


    		
  

  

    
      7
    
    
      
    "P1"."TEST"."Bool4", "P1"."TEST"."Float", "P1"."TEST"."Bool5", "P1"."TEST"."Decimal", 


    		
  

  

    
      8
    
    
      
    NVL2(("P1"."TEST"."Geometry"),("P1"."TEST"."Geometry").Get_WKB(),NULL) 


    		
  

  

    
      9
    
    
      
FROM "P1"."TEST" 


    		
  

  

    
      10
    
    
      
WHERE ( ("P1"."TEST"."ID") = (?) ) AND  ROWNUM <= 1;