SQL query
I have a query as follows -
select
o.oname, i.table_name, i.column_name
from
dba_tab_columns i
join oar_table o on i.table_name = o.oname
where i.owner = 'ABCD'
and i.column_name like '%_CD'
group by o.oname;
I'm trying to return distinct values for the first column (oname) but as you can see, there are 3 duplicate values for ONAME.
ONAME TABLE_NAME COLUMN_NAME
------------------------------ ------------------------------ ------------------------------
CONTACT_SUMMARY CONTACT_SUMMARY LOCATION_TYPE_CD
REG_SUMMARY REG_SUMMARY DEST_COUNTRY_CD
REG_SUMMARY REG_SUMMARY CITIZENSHIP_CD
WAIVER_SUMMARY WAIVER_SUMMARY PA_WAIVER_CD