jarango18

Query sentence

Discussion created by jarango18 on Sep 26, 2013
Latest reply on Oct 3, 2013 by jarango18
Hi, I Have a select query but I don´t know what ArcSDE process execute....

SELECT column_name FROM (SELECT aic.column_name, COUNT (aic.column_name) OVER (PARTITION BY aic.index_name) cnt FROM all_indexes ai, all_ind_columns aic WHERE ai.owner = :owner_name AND ai.table_name = :table_name AND ai.uniqueness = 'UNIQUE' AND ai.index_name = aic.index_name AND ai.owner = aic.index_owner AND ai.table_name = aic.table_name) WHERE cnt = 1

Thanks for your help!!

Outcomes