PL/SQL (MOSC)

MOSC Banner

SQL query

edited Nov 15, 2022 6:44PM in PL/SQL (MOSC) 7 commentsAnswered ✓

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

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center