Someone asked about persisting table filters. Quick answer, we don’t. When you leave and come back to table, the filters are no longer active. Don’t know what I mean by filters? So, if you close the table and come back, the filter won’t be there anymore. MOSTLY. It is there, you just have to ask for it. Ctrl+Space. Now scroll …
Quick Tip: Global Where Clause for Database Exports
Want to export a ton of tables, but only get SOME of the records? Want to apply a GLOBAL filter across the tables to only get the records you want? Tools > Database Export. I’m going to export data, NOT DDL. I’m going to write it to a single JSON file. I’m going to grab data from a couple of …
Filter All The Things
I often spend a lot of time on the ‘cool’ and ‘advanced’ tips and tricks when doing talks for SQL Developer. Today, I’m co-presenting with Helen , and she chose to spotlight a bunch of stuff around filtering. Follow @HelenJSanders I love the topic, but I usually short change the subject in my talks. Today, let’s review all (most??) of …
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 might not be getting the WHOLE truth, or the latest truth. Unless you’ve fetched ALL …
Connection Filtering Across all Schema Objects
Most folks know they can filter their list of Tables. But did you know you can set a global filter across your entire connection? It’s pretty basic, but also pretty powerful: So how would this be useful? Maybe for your project or program module, you have all of the objects starting with the same prefix. You can now filter your …
Defining a RESTful Service in SQL Developer with :BINDS
In a previous episode, I showed how quickly you can REST enable your Oracle Database tables and views. And I took a second or 3 to show how to create a module in SQL Developer’s REST Development panel, which allows you to have a RESTful endpoint served by a SQL statement which will bring your data back as JSON. Today …
Quick Filtering Objects in the Schema Browser
Today’s post is brought to you by a new request to the Exchange this week. They wanted to be able to quickly filter a list of objects without having to open a dialog to do it. For a dynamic browsing of databases with a lot of objects it would be nice to have a textbox where you can filter the …
30 SQL Developer Tips in 30 Days, Day 11: Tree Trimming
Many of you are not DBAs or developers. You spend most of your time browsing tables, running queries, and answering questions that help make your business ‘go.’ The SQL Developer Connection Tree shows a whole lot of stuff that you might not ever use. So turn it off. Tools – Preferences – Database – Navigation Filter By the way, this …
Oracle SQL Developer 4: A Tweak With Table Filters
In previous versions of Oracle SQL Developer, if you start typing in the Data tab’s filter dialog on a Table Editor, SQL Developer would make suggestions for you. A few folks have asked that we not be so aggressive with the ‘help’ here. And I wholeheartedly agree. So in version 4… If You Want Help, Ask For It! So what’s …
Why Can’t I See My Tables in Oracle SQL Developer?
Post updated November 12, 2018. The answer is simple – you can’t see any tables, because you don’t OWN any tables. I hate to be the bearer of bad news, but you don’t have any tables. What you mostly likely DO have are SYNONYMS that point to tables in an application schema. When you log on to Oracle, you are …
- Page 1 of 2
- 1
- 2