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! …
Everything You Need to Know about the Data Grids
Here’s a 15 minute video showing you everything you need to know about using the data grids in Oracle SQL Developer. Basically: settings fonts and look & feel column sizing column(s) sorts client side filtering copy & paste tricks single record view complex data type …
Client Side Filtering in the Grids
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 …
Infographic: Oracle SQL Developer Data Grid Features
There’s quite a few things you can accomplish by manipulating and tweaking our data grids in SQL Developer without having to write a single shred of SQL. I’m not going to flood you with 35 blog posts on the subject. But I’ll share a few …
30 SQL Developer Tips in 30 Days, Day 21: Executing Multiple Statements to Multiple Data Grids
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 …
How to Copy Only Column Headers from Query Results in Oracle SQL Developer
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 …
Copying Columns from Grid to Clipboard in SQL Developer
There are several ways to get data from a query or a table|view to the clipboard. You know the tried and true, copy and paste. But what if you only want one or more columns, not every column? There are several ways to do this, …
Stupid Copy & Paste Tricks
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 …
- Page 1 of 2
- 1
- 2