1
To change the UI language of SQL Developer to English, edit the sqldeveloper.conf file located in the installation bin folder and add the JVM option AddVMOption -Duser.language=EN.
2
Database connections should be assigned a distinct color (especially for production environments) to prevent critical mistakes and easily identify which database is active.
3
Commands can be executed using the toolbar play button or more efficiently via keyboard shortcuts like Ctrl+Enter for single statements and F5 for scripts.
4
SQL Developer's auto-formatting feature (activated via Ctrl+F7) can be customized under Preferences > Database > SQL Formatter to enforce uppercase keywords and specific line breaks.
5
Null values represent the lack of a value (unknown/undefined) and can be highlighted with a distinct background color (like light gray) under Preferences > Database > Advanced.
6
Query results can be preserved by pinning tabs, renaming tab titles, or changing preferences to automatically show results in new tabs.
7
Data export can be performed by copying cells with headers using Ctrl+Shift+C or by using the built-in export wizard supporting formats like Insert statements, PDF, HTML, Excel, XML, and JSON.
8
Code templates allow developers to expand shorthand codes (e.g., typing SSF and pressing Ctrl+Spacebar) into full SQL snippets using placeholders and the Tab key for rapid navigation.