Revision 916 org.gvsig.oracle/trunk/org.gvsig.oracle/org.gvsig.oracle.provider/src/test/resources/org/gvsig/oracle/dal/operations/sql/fetchFeatureType.sql

View differences:

fetchFeatureType.sql
1 1 

  		




  2
  2
  
    
-- FetchFeatureType first row SQL


  		




  3
  
  
    
SELECT * FROM "P1"."test" WHERE  ROWNUM <= 0;


  		




  
  3
  
    
SELECT * FROM "P1"."TEST" WHERE  ROWNUM <= 0;


  		




  4
  4
  
    

  		




  5
  5
  
    
SELECT "USER_TAB_COLS"."COLUMN_NAME", "ALL_CONSTRAINTS"."CONSTRAINT_TYPE" 


  		




  6
  6
  
    
FROM USER_TAB_COLS 


  		




  7
  7
  
    
JOIN ALL_CONS_COLUMNS on (ALL_CONS_COLUMNS.TABLE_NAME = USER_TAB_COLS.TABLE_NAME and ALL_CONS_COLUMNS.COLUMN_NAME = USER_TAB_COLS.COLUMN_NAME) 


  		




  8
  8
  
    
LEFT JOIN ALL_CONSTRAINTS on ALL_CONSTRAINTS.CONSTRAINT_NAME = ALL_CONS_COLUMNS.CONSTRAINT_NAME 


  		




  9
  9
  
    
WHERE ( 


  		




  10
  
  
    
    (( ("USER_TAB_COLS"."TABLE_NAME") LIKE ('test') )) 


  		




  
  10
  
    
    (( ("USER_TAB_COLS"."TABLE_NAME") LIKE ('TEST') )) 


  		




  11
  11
  
    
    AND 


  		




  12
  12
  
    
    (( ("ALL_CONSTRAINTS"."CONSTRAINT_TYPE") = ('P') )) 


  		




  13
  13
  
    
);


  		












Also available in:  Unified diff