A user was unable to query data from tables in sql developer, the query worked fine in sqlplus and toad.
Upon checking the NLS settings were different in the SQL Developer.
After the changing the NLS settings in the sql developer as follows, the issue got resolved.
SQL Developer > Tools > Preferences.. > Database > NLS
Recent Posts