3

How do you add folders on the left side of the Open Folder interface? In one of my previous versions of the installation I had a couple different folders I frequently used in that part of the interface. Now I can't figure out how I got them there.

Using the standard Windows Folder icon to open a file (or File -> Open, or Ctrl-O). The window that pops up has on the left side "Home", "Desktop", and "Documents" as shortcuts to click on. There's space for more shortcuts and in a previous installation I actually had two more shortcuts to locations I used frequently. How do you add folders to that shortcut list?

Burgi
  • 6,768
JustAGuy
  • 41

5 Answers5

4

If your version is 3.2.20.09 then you can set it up at Tools > Preferences > Database > Worksheet > Select default path to look for scripts

guest guest
  • 41
1

Turns out that if you open a certain folder often enough that it will add a shortcut to that location above the "Home", "Desktop", and "Documents" icons.

I still don't know if there's an option somewhere to manually add frequently opened locations to the File Open (Ctrl-O) dialogue window or what if you wanted to edit which shortcuts you have available there in a case where maybe you have multiple folders you open files from often. Sounds like a quality of life improvement opportunity for the developers of the software.

JustAGuy
  • 41
0

If you are on Windows and want to add or remove those folders that show in the PlacesBar, try this...Go to "%appdata%\SQL Developer". In that folder you will see one or more folders that start with "system" and have the versio number. Each one is from an installation or update of SQL Developer. Find the one you are using (biggest version number??) and search for two files (preferences.xml and product-preferences.xml).

Inside these files were lots of relative paths to the files I've opened. I just deleted a bunch that were in folders I didn't want to see anymore. That was good enough to clean up my PlacesBar. I'm not sure which deletes did the trick. Maybe someone else (or google search) can give an explanation of the sections found in those files.

Jim
  • 1
0

Do you refer to View > Files, or something completely else? Be more specific, please. I have SQLd opened right now (like any other day) and quickly run through a few less used options but can't figure out what you mean.

Ren
  • 33
-1

Actually I am using SQL Developer 21.4.3 and in View tab you can actually open the location where your sql files are stored by Selecting "Files" option. For me on my mac, I store all my .sql files in ~/worksapce/sql-projects/sql-demo. I can navigate there and just double-click on any sql file I want to execute.enter image description here

Viswajit Nayak
  • 1