developer - Laur's blog

Sign in Subscribe

developer

A collection of 3 posts

Export SQL Developer Connections

Export SQL Developer Connections

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

Build Update Statements with Oracle SQL Developer and Python

Build Update Statements with Oracle SQL Developer and Python

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

Move SQL Developer Data from the Roaming Profile in Windows

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: