5 Replies Latest reply: Dec 28, 2012 5:10 AM by AlbertoFaenza RSS

    how to check the multi-security enabled column using join condition

    959687
      {How to check how many companies in production DB have multi-security enabled and what are their ML_SEC_NUM in TB_FC_COMPY?
      How to identify multi-sec is TB_FC_COPY. multi_security_flag = ‘Y’
      Then using ml_sec_num from tb_fc_compy check against ml_sec_num in TB_F_ACCD_IN table with IVR_PLAN_NUM join and see the difference.}
        • 1. Re: how to check the multi-security enabled column using join condition
          AlbertoFaenza
          Hi,

          Please read SQL and PL/SQL FAQ

          Additionally when you put some code or output please enclose it between two lines starting with {noformat}
          {noformat}
          
          i.e.:
          {noformat}
          {noformat}
          SELECT ...
          {noformat}
          {noformat}
          
          Please post table structure (CREATE TABLE) and sample data (INSERT statement).
          We cannot answer to your question without having tables you are referring to.
          
          In order to get a faster answer describe in a more detailed way your requirement.
          
          Regards.
          Al                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            
          • 2. Re: how to check the multi-security enabled column using join condition
            Purvesh K
            > {quote:title=956684 wrote:}{quote} > {How to check how many companies in production DB have multi-security enabled and what are their ML_SEC_NUM in TB_FC_COMPY? Without your table structure, it is not possible to answer the question. However, assuming the data and column, below is my best try to it: {code} /* This query gives you Distinct Company with Multi Security Flag as Y */ select distinct company_name   from TB_FC_COMPY where multi_security_flag = 'Y'; > How to identify multi-sec is TB_FC_COPY. multi_security_flag = ‘Y’ Did you mean what values does MULTI_SECURITY_FLAG hold? If Yes, then use below: {code} select distinct multi_security_flag   from tb_fc_compy; {code} > Then using ml_sec_num from tb_fc_compy check against ml_sec_num in TB_F_ACCD_IN table with IVR_PLAN_NUM join and see the difference.} What difference are you talking of? You need to elaborate the requirements. And please do consider that We do not hold a Crystal Ball that allows us to access your Database and check for your data, structures and your requirements. So, if you do not help by providing adequate information, I would be best not to hope a Helpful reply.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               
            • 3. Re: how to check the multi-security enabled column using join condition
              959687
              { columns for TB_FC_COMPY: IVR_PLAN_NUM, ML_SEC_NUM, multi_security_flag, IVR_PLAN_NUM, etc

              columns for TB_FC_COMPY: IVR_PLAN_NUM, ML_SEC_NUM, IVR_PLAN_NUM}
              {check how many companies in UAT4 have multi-security enabled and what are their ML_SEC_NUM in TB_FC_COMPY?

              How to identify multi-sec is TB_FC_COMPY. multi_security_flag = ‘Y’
              Then using ml_sec_num from tb_fc_compy check against ml_sec_num in TB_XOP_ACCTFEED_IN table with IVR_PLAN_NUM join and see the difference.}

              {How to identify userwise count}
              • 4. Re: how to check the multi-security enabled column using join condition
                Purvesh K
                956684 wrote:
                { columns for TB_FC_COMPY: IVR_PLAN_NUM, ML_SEC_NUM, multi_security_flag, IVR_PLAN_NUM, etc

                columns for TB_FC_COMPY: IVR_PLAN_NUM, ML_SEC_NUM, IVR_PLAN_NUM}
                {check how many companies in UAT4 have multi-security enabled and what are their ML_SEC_NUM in TB_FC_COMPY?

                How to identify multi-sec is TB_FC_COMPY. multi_security_flag = ‘Y’
                Then using ml_sec_num from tb_fc_compy check against ml_sec_num in TB_XOP_ACCTFEED_IN table with IVR_PLAN_NUM join and see the difference.}

                {How to identify userwise count}
                Tell me, which part of the Post linked in Alberto's reply, did you not understand? Did you even bother to read it?

                And what is the reason for using Curly Braces? Are they for emphasis?

                I still do not find your reply useful to reply on. Unless you give us Table Structures, Data that we can replicate, it is not helpful. So, it will be your choice to improvise or stay the way it is.
                • 5. Re: how to check the multi-security enabled column using join condition
                  AlbertoFaenza
                  956684 wrote:
                  { columns for TB_FC_COMPY: IVR_PLAN_NUM, ML_SEC_NUM, multi_security_flag, IVR_PLAN_NUM, etc

                  columns for TB_FC_COMPY: IVR_PLAN_NUM, ML_SEC_NUM, IVR_PLAN_NUM}
                  {check how many companies in UAT4 have multi-security enabled and what are their ML_SEC_NUM in TB_FC_COMPY?

                  How to identify multi-sec is TB_FC_COMPY. multi_security_flag = ‘Y’
                  Then using ml_sec_num from tb_fc_compy check against ml_sec_num in TB_XOP_ACCTFEED_IN table with IVR_PLAN_NUM join and see the difference.}

                  {How to identify userwise count}
                  If you consider this an answer to my recommendations and request I think you are in a wrong place.
                  There is nobody who can read your mind in this forum. :)

                  Read again my previous post and try again.

                  Regards.
                  Al