SQL Performance (MOSC)

MOSC Banner

1 Query and 2 different results

edited Jul 2, 2014 5:00AM in SQL Performance (MOSC) 3 commentsAnswered

Hello everyone,

I found some new feature/ BUG for version 11.2.0.2.0 single instance and also RAC .

My query:

SELECT  bp.hbp_name_tx ,bp.hbp_price_total_nr, bp.hbp_price_base_nr, bp.hbp_price_tax_nr, bp.hbp_id

        FROM HSI_VES.hsi_akce a, hsi_ves.ves_pozadavek_zpoplatneni_v pz,

             HSI_CMP.hsi_billing_price bp

       WHERE

         a.vea_id=(select rlr_ref_object_id from HSI_RL.rl_request r where r.rlr_ident_tx='1114000173')

         AND pz.vea_vea_id = a.vea_id

         AND bp.hbp_name_tx = 'DGN'

         AND bp.vat_vat_id = a.vat_vat_id

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