Tags » SQL Developer

Execute Statement or Run Script?

Run Statement will give you a list of all the results in a sortable table. It will also only run the statement under the cursor (or highlighted). 69 more words

Oracle

SQLDeveloper VAR NUMBER

Just been tearing my hair out on some unexpected SQL behaviour in SQL Developer.
Eventually I managed to get to the root cause of the problem as illustrated below. 149 more words

Oracle

Generate Database Data Dictionary Using Oracle SQL Developer

Data dictionary is a handy reference for SQL developer and programmer to know where to find out data. Thanks to Oracle SQL Developer, we can generate data dictionary from a database schema painlessly. 56 more words

Database

SQL Developer 3 and Timestamp Conversion

I shouldn’t be using an old version of SQL Developer like v3 (3.2.10.09) anyway but… cut a long story short … I am.
I’ve also got v4 which doesn’t display the same problem… 519 more words

Oracle

Is there a way to configure the directory SQL Developer uses to save SQL scripts?

When you go to save your sql file you can change where the save defaults to. Change it in Tools>Preferences>Database>Worksheet Parameters. You can browse to a new location under “Select default path to look for scripts” 62 more words

Oracle

Optimizing working environment. Part I, GUI

Working with database performance troubleshooting means dealing with challenging and exciting problems. But it also means doing certain things over and over. And over. Like typing the same query or clicking the same button zillion times a day.  1,227 more words

Tools