This discussion is archived
5 Replies Latest reply: Dec 28, 2012 3:10 AM by AlbertoFaenza RSS

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

959687 Newbie
Currently Being Moderated
{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 Expert
    Currently Being Moderated
    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 Guru
    Currently Being Moderated
    > {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 Newbie
    Currently Being Moderated
    { 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 Guru
    Currently Being Moderated
    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 Expert
    Currently Being Moderated
    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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points