Content Tagged "developer"

When I joined in, I found myself suddenly needing access to a bunch of Oracle databases, so I thought initially to get all accounts loaded one by one in SQL Developer. That's an option... A colleague showed me that you can actually back up and restore your DB connections in a few simple steps: Open…

By default, SQL Developer can only export INSERT statements. This is quite unfortunate when one needs to build UPDATE statements because their syntax is different. I've tried to use regexp to convert the statements but I didn't find it not straight forward at all. So, I cam up with the following…

TL;DR: : Set up IDE_USER_DIR . I have to keep my roaming profile on a diet and this means moving a bunch of default directories around. The latest victim is SQL Developer According to this post , the environment variable to be changed is IDE_USER_DIR . From the post: According to documentation…