Post reply

To Determine how many columns matched in a query and getting percentage matched

  • April 21, 2009 at 6:24 am

    #220503

    Hi All,

    Does any one have an idea regarding how can we get the no of columns which are matched in a query and accordingly depending upon the matched columns get the percentage which is matched.

    Any help will be kindly appreciated.

    Thanking you,

    Syed Tameemuddin

  • April 22, 2009 at 9:52 am

    #982295

    Not sure if I follow.

    Are you referring to rows that match the predicate vs. rows that do not match the predicate of a given query?

    _____________________________________
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at Amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

  • April 25, 2009 at 4:30 am

    #983920

    Hi,

    I want in a single row how many columns are matching and accordingly get the percentage of columns matched.

  • April 25, 2009 at 4:31 am

    #983921

    Hi,

    I want in a single row how many columns are matching and accordingly get the percentage of columns matched in a single row

    Thanks,

  • April 25, 2009 at 6:58 am

    #983941

    This doesn't sounds like a "Working with Oracle" kind of question.

    Eitherway -not considering the merits of the exercise - you can join both tables, load all columns of each row of each table in two cursors then loop the cursos comparing columns values one at a time and do the math.

    _____________________________________
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at Amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply