I had a pretty good week of presenting at Open World this week. 3 solo presentations, all well attended. But in one, I had a technical issue – that’s code for I was having problems because I was using the wrong database connection – when trying to show off the Real Time SQL Monitoring support feature in Oracle SQL Developer. So in case you were there, and left a bit disappointed, I cut this quick…
You have a query. You run a query. Now how can I take that data and make it available in a web browser or application? Export as HTML You can of course export your resultset as HTML using the Grid, right mouse, Export, to HTML. This will give you something like this… Don’t forget the hint! Remember, lazy-dev method: 13895428186725560406488_000000 And execute as script (F5) gives me this: 13895428186725560406488_000001 But the Internet wants more pictures!…
Around 60 of us Oracle folks showed up this morning to take a little run across the Golden Gate Bridge. It took effort to get out, effort to run, and a lot effort to jump for 30 or 40 pictures – thanks Yury! The Database tools team showed up in force – 4 of us SQL Developer types and more than a few of the Oracle APEX developers came out to support the event. We…
The crazy starts tomorrow. Most of you won’t be here. But. You can get the software being used to demo everything this week. The Developer Day VirtualBox image has been updated as of yesterday. The biggest update is that it has 12.1.0.2 of the database on it. All that In-Memory awesomeness 🙂 No pics today, I’m writing this in a taxi on our way to an Oracle nerd beer meetup! Ok, I started it on…
We get lots of questions around how to model specific partitioning schemes in Oracle SQL Developer Data Modeler, and we do support all of the different ways to part and subpart your data – but today I want to show you: Where to see the partitions in the model How to bring in everything BUT the partitions Where are my partitions? When looking at the table in your data model, you won’t see the partitions…
Many applications will create user accounts in the database that do not own anything. They have privs to query the main application schema, but will never be used to create tables, views, etc. When you’re browsing the database via the Tree in SQL Developer, you probably won’t want to see these ‘fake’ users. Just Apply a Filter Make sure your data dictionary stats are up to date – this extra check for object counts could…
As much as I like the traditional explain plan support in SQL Developer, and even the ability to pull cached plans out by the SQL_ID – sometimes you just want to get the plan the old fashioned way. The New Way The Older Way Ugh. That’s a little icky to read. Remember – you need to set a fixed-width font. Tools – Preferences – Code Editor – Fonts Fonts Are Very Important If you’re having…
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 resultset grid gives you a context hint as to the query used to populate said…
Quick and clean, what’s that? Consider the following: 13895428186725560406488_000003 I call that ‘quick and dirty,’ and I imagine you have used this technique many, many times. But, I wish it would have grabbed column comments, indexes, maybe even the partitions. Partitioning a table after the fact is pretty much a no-go. So what are we to do? Well, if you have SQL Developer v4.0.3, you can simply right-click on a table and… Use as a…
This post was almost NULL – I was deep in Power Point mode for Open World, and almost forgot to write today’s post! Also, another admission: I said back on Day 1 of this series, that I was planning on doing 5000 push-ups this month as well. Well, I gave up on that a few days ago. I’m still pushing them out, but 5,000 ain’t going to happen – sorry Philip! Ok, conscience clean -…