One of the most viewed threads over the last 30 days in our OTN Community for SQL Developer is a post from 2010. 2010. Wow, I says to myself – that’s gotta be interesting to a lot of folks, what is it? It’s a question on how to find table or view columns. And the ‘correct’ answer is to use SQL. Which is of course the right answer, and was the right answer in 2010…
It’s that time of year again: planning for our biggest customer and user event, Oracle Open World. I recently shared some advice for getting the most out of your conference experience, here’s a 2 minute video: One of the bits there I suggested was to mark one or two sessions a day that you might want to attend. Well, since you’re here, I’m assuming you might find the stuff our team is doing appealing. Note…
Haven’t had much time to blog this week, so what’s a blogging addict to do? Ask your readers for help! @thatjeffsmith kind of like db instance but more focused. I picked 3 just to give an idea. Refresh would be on all. pic.twitter.com/WUlWyUbeT3— Nando Somoza (@slaytanic70) September 10, 2015 So I put together this view for Nando…3 reports running all at once, and all displayed at once. Blocking Locks by User (top left) ASH Rows…
You’ve just installed a new copy of SQL Developer. Here are some things you might want to change in the preferences. Notes: I said ‘fixed field’ – I meant FIXED WIDTH fonts, duh If you think you’re hearing Foreigner’s Feels Like The First Time, you’re wrong Some of the tips in blog format: fonts zebra line numbers open on SINGLE CLICK! connection folders query results new grids
We store the application settings PER user. So find where your OS stores files for your OS user. These settings are stored HERE on Windows (…AppData\Roaming\SQL Developer): They are stored HERE on Macs and *NIX ($HOME\.sqldeveloper): Find the directory that corresponds with the version you are running and having problems with. Rename it. Restart SQL Developer – you should be running ‘stock, out of the box.’ This can also come in handy any time the…
This isn’t a SQL Developer post, sorry folks. When it takes me more than a couple of Google searches and more than a little bit of poking around to figure something out, I reckon it’s blog-post-worthy. Maybe I can save you a bit of time too! I have: a 12.1.0.2 database the JSON patchset a table said table with IS JSON CHECK constraint some json docs that contain nested arrays So it looks a little…
Columbus didn’t exactly discover America. And we’re not really going to discover your long, lost foreign keys. But, we’ll do our best to guess where they might be. Our data modeling tool is often the bearer of bad news – your database doesn’t actually have any referential integrity defined. Oh, it’s defined somewhere, in the application. Probably. Just not in the database. (I realize these aren’t complete sentences, but this is a blog post, not…
Do you know someone who helps make our data safer, and more useful in the Oracle Database space? This could be an architect, engineer, data modeler – whatever, that works in the design area and shares their work and insight with the rest of the community. Someone who has something much more interesting to say than me: Please don't name your tables "FROM"— Jeff Smith (@thatjeffsmith) August 11, 2015 Oracle is hosting a Database Developer…
Today’s question: can I design a table that takes advantage of the new Temporal Validity feature in Oracle Database 12c? Today’s answer: ‘Yes.’ In a nutshell: Temporal Validity Support lets you associate one or more valid time dimensions with a table and have data be visible depending on its time-based validity, as determined by the start and end dates or time stamps of the period for which a given record is considered valid. Examples of…
Had a real fun time showing off a series of tips & tricks yesterday, and we did it all in 15 minutes! I can’t afford Mike Rowe or Morgan Freeman for voice over talent, so unfortunately this video has my voice. The things I show in this video, in blog form: SQL History Recall SQL Code Templates Joining multiple tables in a SELECT Query Builder Code Snippets Completion Insight SQL Text Expansion I hope my…