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…
Looking for more good content around the Oracle Database? Here’s a list of great Oracle Bloggers that I think you should know and follow!
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
These are just my opinions, and I don’t speak on behalf of my employer. On the Facebookers this morning, noticed one of my friends was contemplating coming out to San Francisco this year to join approximately 50,000 other Oracle and Java-heads for Java One and Oracle Open World. I’m not going to try to sell you on this event – the location alone should be enough to get most of you excited. San Francisco is…
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…
I was remarking to someone this morning how easy I thought it was to setup a job, say on the first and third Wednesday of the month. The flexibility of DBMS_SCHEDULER, even without taking into account the power of schedules, is really powerful. We have a scheduler wizard that puts a graphical user interface onto the DBMS_SCHEDULER package. Here’s how it works, in a decent sized nutshell. Which will launch… Clicking the edit button opens…
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…
SQL can be hard to read. Execution plans can be EVEN HARDER to read. It doesn’t get any easier when you are joining a table to itself. Or maybe you are having a hard time finding the portion of a plan to correlates to a subquery. We do have a solution! QB_NAME Hint (Docs) /*+ QB_NAME ( qb_name ) */ So why am I talking about this today? Well one of our SQL Advocates, Connor…
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…
Do as I say, not as I do. Because I am like most of you, I am very lazy. Case in point: loading some data from a CSV into an Oracle table. I can use a wizard in SQL Developer and in a few clicks, have it loaded. Usually I’m playing with a hundred rows. Or maybe a few thousand. But this time I needed to load up about 150MB of CSV, which isn’t very…