No data displayed for some tables EBS with SQL Developer V18
when select data from some tables such as fa_additions using sql developper v18, no row displayed.
select * from fa_additions
No rows
This will not the only view showing no rows. but all synonyms for views creating with the T.LANGUAGE = userenv('LANG');
to check the nls lang from sql developer,
select userenv('LANG') from dual;
GB.
To change the LANG in sql developer, please to
1. Start sqldeveloper.
2. Go to Tools-->preferences-->database-->NLS parameters.
3. Change LANGUAGE to AMERICAN.
4. Restart sql developer.
The data will displayed normally now.
when select data from some tables such as fa_additions using sql developper v18, no row displayed.
select * from fa_additions
No rows
This will not the only view showing no rows. but all synonyms for views creating with the T.LANGUAGE = userenv('LANG');
to check the nls lang from sql developer,
select userenv('LANG') from dual;
GB.
To change the LANG in sql developer, please to
1. Start sqldeveloper.
2. Go to Tools-->preferences-->database-->NLS parameters.
3. Change LANGUAGE to AMERICAN.
4. Restart sql developer.
The data will displayed normally now.
No comments:
Post a Comment