Error running Toad with MS OS: "LexLib.lxl was not found and is needed."

Description

At the startup of Toad, the following error message is shown: 'LexLib.lxl was not found and is needed' on machine.

• Resolution
• WORKAROUND:
  Locate the LexLib.new file, located in the Toad for Oracle\User Files folder and rename the file to LexLib.lxl.
  (Note: This file maybe a hidden file under the Toad for Oracle folder.)

frm-40039 or frm-10102 can't attach PL/SQL library while opening form

Problem: FRM-10102: Cannot attach PL/SQL library APPCORE. 

This library attachment will be lost if the module is saved Solution. 

Need to add FORMS_PATH  in registry of windows.

Press Win R to open windows Run and put regedit to edit the windows registry.

and search ofr FORMS_PATH and custom Forms and plls path in this variable.

OR

FORMS_path variable in regedit.

   FOTMS_PATH=c:\DevSuiteHome_1\cgenf61\admin;

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';