NLS_LANGUAGE FOR R12 In client/SQL Developer
Posted: Sat Aug 09, 2025 5:54 am
If you are connected with Oracle EBS R12 instance and trying to get data but it is showing no record then do this setting,
1. select * from hr_operating_units;
no data
2.ALTER SESSION SET NLS_LANGUAGE= 'AMERICAN';
select * from nls_session_parameters;
3. select * from hr_operating_units;
Now it will show data.
if you are using Oracle SQL developer then do these setting,
Tools>Preferences>Database>NLS: Language = AMERICAN
1. select * from hr_operating_units;
no data
2.ALTER SESSION SET NLS_LANGUAGE= 'AMERICAN';
select * from nls_session_parameters;
3. select * from hr_operating_units;
Now it will show data.
if you are using Oracle SQL developer then do these setting,
Tools>Preferences>Database>NLS: Language = AMERICAN