Saturday, 6 February 2016

Some tables and views data not shown in Oracle SQL Developer IDE

Daily oracle developer normally use the SQL Developer IDE but one day facing the challenging issue SQL Developer not showing tables and views data, we use the following steps to resolve this issue.

There are two Method to short out this problem.

                                                                                    Method 1:
Step 1. Go to Tools Tab and click on Preferences.
Step 2. Go to Database Tab and click on NLS.

Then we check the NLS Language of Oracle SQL Developer IDE.
            If NLS Language of Oracle SQL Developer IDE are other then AMERICAN
            then Set As:


Method 2:

Execute the below query:

ALTER SYSTEM SET NLS_LANGUAGE='AMERICAN';





No comments:

Post a Comment