Database Administration (MOSC)

MOSC Banner

implicit conversion in 11g

edited Oct 30, 2014 10:01AM in Database Administration (MOSC) 1 commentAnswered

The below query is not working in 11.2.0.4 and the same works fine in all 10.2.0.4 environments. If we put TO_CHAR for (store.store) it works fine.

We have some 1000's of objects having this kind of queries.

   select distinct addr.country_id

        from store, store_hierarchy, wh_ext, wh, csi_uda_lov, addr

        where store.store = store_hierarchy.store

        and store_hierarchy.chain = 1

        and store.store = csi_uda_lov.store_num

        and csi_uda_lov.csi_uda_gid = 3306

        and store.default_wh = wh.wh

        and wh.physical_wh = wh_ext.wh

        and wh_ext.dc_cd = substr('US1BU',1,3)

        and addr.key_value_1 = store.store -- Existing

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