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
sql
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.
Delete Dependent Entries of a Table in Oracle PL/SQL
The other day I had a task to clean up a database which was populated with a list of records. Unfortunately, my main table is
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
TIL you can mix ASC, DESC in ORDER BY (SQLite)
TL;DR: You can use ORDER BY column1 DESC, column2 ASC ... in your code.
The other day I was trying to get a custom ordering