SQL Developer 17.2: Publish RESTful Service (GET) based on a Data Grid

thatjeffsmith ORDS, SQL Developer 0 Comments

Think building REST Services for Oracle Database is hard? Tooling around SQL Developer, browsing data, and thought to yourself, that would make a great Web Service? Now, you can quickly publish the query behind a grid to a new or existing ORDS Module. Just right-click! (well wait a second, you need ORDS installed and configured for your database. And the …

Client Side Filtering in the Grids

thatjeffsmith SQL Developer 0 Comments

Just what it sounds like – you ask to see LESS data in a grid, and we don’t re-query the database. Instead, we filter only on the client-side. This means it’s FAST. No asking the database to run the query again. This also means you might not be getting the WHOLE truth, or the latest truth. Unless you’ve fetched ALL …

30 SQL Developer Tips in 30 Days, Day 21: Executing Multiple Statements to Multiple Data Grids

thatjeffsmith SQL Developer 0 Comments

Impatient? Want to run a query, then run another – getting both sets of results to a data grid? Don’t mind leaving cursors open? These are serious questions. But if you’re feeling adventurous, feel free to try this out. Select multiple queries Execute Or, if you prefer to watch the movie… Did you notice that ‘bonus’ tip? Mousing over the …

How to Copy Only Column Headers from Query Results in Oracle SQL Developer

thatjeffsmith SQL Developer 8 Comments

Short and sweet post today – let’s say you’ve written a SELECT *, and your query results have some column headers you want to copy out. Yes, you could copy out the result set WITH the column headers, but maybe you JUST want the column names themselves. Note you need to select which column headers you want copied by selecting …

Stupid Copy & Paste Tricks

thatjeffsmith SQL Developer 43 Comments

The Late Show with David Letterman used to have a bit called, ‘Stupid Pet Tricks.’ I quit watching because I prefer his Scottish and funnier future-replacement, Craig Ferguson. But I will take advantage of some Google-Fu to drive some traffic to ye olde blog (can you tell I’m in the UK this week?) So most folks GET copy and paste …