1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

No data in fa_additions in sql developer 4.1.1.19.

Discussion in 'SQL PL/SQL' started by jagadekara, Jul 17, 2015.

  1. jagadekara

    jagadekara Forum Guru

    Messages:
    1,126
    Likes Received:
    145
    Trophy Points:
    1,805
    Location:
    Pulivendula
    Hi All,

    select * from fa_additions

    No rows

    In Sql Developer 4.1.1.19.

    When I check in Sql developer lower version , it shows data.
     
  2. RG Hegde

    RG Hegde Forum Advisor

    Messages:
    185
    Likes Received:
    35
    Trophy Points:
    310
    Location:
    Pune
    can you check the table fa_additions_b
     
  3. jagadekara

    jagadekara Forum Guru

    Messages:
    1,126
    Likes Received:
    145
    Trophy Points:
    1,805
    Location:
    Pulivendula
    Hi,

    Fa_additions_b has data, But I need fa_additions only.

    Why it is not showing data in latest version of sql developer?
     
  4. sambuduk

    sambuduk Forum Advisor

    Messages:
    242
    Likes Received:
    73
    Trophy Points:
    455
    Location:
    Hyderabad , Telangana
    Hi jagadekar,

    Fa_additions is a synonym for Fa_additions_vl view. In that view they are using the T.LANGUAGE = userenv('LANG'); . Are you getting output for the following query?

    select userenv('LANG') from dual;


    --
    Sambasiva Reddy.K
     
    jagadekara and RG Hegde like this.
  5. RG Hegde

    RG Hegde Forum Advisor

    Messages:
    185
    Likes Received:
    35
    Trophy Points:
    310
    Location:
    Pune
    As it is View might be the condition AND t.LANGUAGE = USERENV ('LANG'); is not working properly in SQL developer.
     
    jagadekara likes this.
  6. sambuduk

    sambuduk Forum Advisor

    Messages:
    242
    Likes Received:
    73
    Trophy Points:
    455
    Location:
    Hyderabad , Telangana
    Hi Jagadekar,

    If that query is not returning value. plz do the following steps

    1. Start sqldeveloper.
    2. Go to Tools-->preferences-->database-->NLS parameters.
    3. Change LANGUAGE to AMERICAN.
    4. Restart sql developer.

    Regards
    Sambasiva Reddy.K
     
    jagadekara likes this.
  7. jagadekara

    jagadekara Forum Guru

    Messages:
    1,126
    Likes Received:
    145
    Trophy Points:
    1,805
    Location:
    Pulivendula
    Thanks All,

    Earlier language has GB. Now changed to US.