1. SQL Developer for VS Code
  2. Using SQL Developer for VS Code
  3. Using Preferences

3.7 Using Preferences

To modify SQL Developer preferences, from the File menu, select Preferences and then Settings. Under User, expand Extensions and select Oracle SQL Developer Extension for VS Code.

The preferences available are:

Database Connections

  • Tns Configuration Path: Enter the location of the tnsnames.ora file.

  • Startup Script Path: Specify the location for the startup script to run when an Oracle database connection is opened. The default location is the default path for scripts.

  • Connections Tree

    Folders Fetch Size: Specifies the maximum number of rows to be fetched at a time into the data grid display for nodes such as Tables, Views, Materialized Views,

Database NLS

The NLS settings specify values for globalization support parameters, such as the language, territory, sort preference, and date format. These parameter values are used for SQL Developer session operations, such as for statements executed using the SQL Worksheet and for the National Language Support Parameters report. Specifying values in this preferences pane does not apply those values to the underlying database itself. To change the database settings, you must change the appropriate initialization parameters and restart the database.

Note that SQL Developer does not use default values from the current system for globalization support parameters; instead, SQL Developer, when initially installed, by default uses parameter values that include the following:

NLS_LANG,"ENGLISH"
NLS_TERR,"AMERICA"
NLS_CHAR,"AL32UTF8"
NLS_SORT,"BINARY"
NLS_CAL,"GREGORIAN"
NLS_DATE_LANG,"ENGLISH"
NLS_DATE_FORM,"DD-MM-RR"

SQL History

  • History Limit: Maximum number of statements that can be stored in SQL History.

Telemetry

  • Allow automated usage reporting to Oracle: Determines whether you consent to usage reporting. If you consent, automated reports can occasionally be sent to Oracle describing the product features in use. No personally identifiable information will be sent and the report will not affect performance.

SQL Worksheet

  • Explain Plan: Determines the level of details displayed in the Explain Plan.