Oracle SQL Developer Version 18.4 Sneak Peek

thatjeffsmith SQL Developer 13 Comments

So someone asked us on Twitter this morning about a new Document that opens on an Export of a query result set. How can I prevent the "Export Tool" log in SQL Developer 18.3?I get it whenever I create some DDL over the navigation [email protected] @OracleSQLDev #sqldeveloper pic.twitter.com/8zyfquqxZ6 — Tobias Arnhold (@tobias_arnhold) November 15, 2018 The short answer is, that …

What the SQL? (History)

thatjeffsmith SQL Developer 6 Comments

Oracle SQL Developer has 2 client-side logging mechanisms for capturing SQL that is executed: SQL History Statements SQL History This is the SQL that you have executed in a SQL Worksheet. It’s also any scripts you have executed in a SQL Worksheet. Ran something the other day and forgot to save it to your script? No worries, pull it up …

SQL Developer 4.1 – Log All the Queries!

thatjeffsmith SQL Developer 25 Comments

Oracle SQL Developer is a graphical user interface and integrated development environment for Oracle Database. As you can imagine, a few clicks can results in an awful lot of queries being executed on your behalf. If you don’t like this fact, you can always use a command-line interface like SQL*Plus or the new sdsql. The only thing that runs there …

Truncates ARE Logged

thatjeffsmith Database Stuff 4 Comments

Someone asked me yesterday where do I get my blog topics and ideas from. Usually it’s from watching too much TV, but often it’s an actual question or topic that is raised by a co-worker or customer. Yesterday I was asked by my boss about how to find out when TRUNCATEs have been issued because I know that truncates cannot …