Below you'll find a list of all posts that have been tagged as “tips”
I’ll show you 3 cool tips and tricks for working with PL/SQL in SQL Developer…in under 7 minutes! In-code navigation – click into where your objects are declared Test Query – see if your SQL is gonna work BEFORE you compile it Using the Code Outline For those that can’t do video, basically you can Ctrl-Mouse-Hover Navigate ANYWHERE Not just …
Not able to make my Tips & Tricks talk at the Great Lakes Oracle User Group conference this week? Don’t have the 50 minutes to watch my recorded YouTube version? Can you spare 90 seconds? You don’t even need to turn the sound on. Just watch this GIF. To recap: ALT+G to do a search Use Doc Tab Groups to …
I’m in Denver today, to present one of my favorite talks, SQL Developer Tips & Tricks. Since I know most of you won’t be here today, I thought I’d share 3, super-quick tips. I get asked ‘how to do this’ type stuff, all the time. Copying Column Headers with your Data Ctrl+Shift+C Showing Line Numbers Right-click in the gutter, …
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 support – Spatial & BLOBs dates & timestamps inserting multiple rows via PASTE I do …
We tried 15 minute talks at a conference last week, and I think they came out OK. I figured for the folks who weren’t able to come out to the conference, maybe you’d like to see the talk? So here it is. The basic gist of the talk: SQL Dev is a BIG, DEEP tool You don’t have time to …
I made some small, but important changes to my SQL Developer Tips & Tricks slide deck. changed up the order – the first two tricks ARE THE MOST IMPORTANT now optimized for SlideShare – hopefully easier to consume in case I’m not there to narrate/live demo added a few teasers for SQLcl I really, really need about 90 minutes to …
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 …
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 …
I love performing my tips & tricks session. No two talks are alike. I frequently update the slides and content to account for new things I’ve learned and new features we’ve added. But. I’ve been delivering this talk going on 4 years now. Should I let my talk at Open World 2015 be my last hurrah of this topic for …
One of the coolest bits of The Matrix, was the ability for the main characters to ‘download’ new skills or objects into their virtual reality. Like Neo could learn Kung-Fu with a simple button click. Today, I want all of you to take the (Oracle) Red Pill, and download your SQLDev knowledge pack. These are things that I see people …