So for some reason, our New Hire Program invited me BACK to talk to our newly hired developers. I had an hour to talk about our development tools, but I wouldn’t call it training really. My colleague Joel does an actual 2 hour lab teaching them to use APEX – that’s closer to REAL training. So given an hour, and being the lead up into the lunch hour, what should I say? I like bully…
Got this question over the weekend via a friend and Oracle ACE Director, so I thought I would share the answer here. If you want to quickly generate DDL to create VIEWs for all the tables in your system, the easiest way to do that with SQL Developer is to create a data model. Wait, why would I want to do this? StackOverflow has a few things to say on this subject… So, start with…
I was testing a reported bug in SQL Developer today – so the bug I was looking for wasn’t there (YES!) but I found a different one (NO!) – and I was getting frustrated by having to check the same boxes over and over again. What I wanted was INSERT STATEMENTS to the CLIPBOARD. I’m always doing the same thing, over and over again. And I never go to FILE – that’s too permanent for…
Another great webcast yesterday – if you’re a paying member of ODTUG you can watch the show for yourself in their archives. If not, you can get my slide deck off of SlideShare. About 150 of you brave souls sat through an entire hour of me talking and then 10 more minutes of Q&A. We went through everything rapid-fire style, so I thought I would post the questions and my refined answers here for your…
Do you find yourself always scrolling and scrolling and scrolling to get to the column you want to see when looking at a table or view’s data? Don’t do that! Instead, just right-click on the column headers, select ‘Columns’, and reorder as desired. Then move up the columns you want to see first… This will only change how the data is displayed for you, and SQL Developer will remember this ordering until you ‘Delete Persisted…
A new feature in Oracle SQL Developer Data Modeler is the ability to display table and view comments directly in the ERD. So I can go from this: Normal Relational Diagram to Relational Diagram with Comments to Relational Diagram with Comments ONLY Now the cool part is that I don’t have to pick. I can use all three depending on my need. Maybe I need a dev diagram for folks in the know, another diagram…
My alternate title for this post was How to get the DBAs’ attention with lots and lots of connections in her database. But I decided to go with substance over style instead. Anyways, let’s talk about connections in SQL Developer for a bit – you know you need the refresher! By default, connecting to a database in SQL Developer opens 2 connections Main connection Insight connection for figuring out what text is a table and…
This question has come up a few times recently. One person asked how to compare 2 SQL statements at Open World. In fact, they claimed if I could show them how to do it, it would make the trip to San Francisco worth every penny. Don’t be surprised they left extremely satisfied 🙂 Then just yesterday, someone else asked how to see the differences between their code objects in the database and their file system.…
Another busy, crazy, awesome week is behind us. I’m going to call it a success, but before I completely file it away, I wanted to share a few quick thoughts, and say thanks to a few people for their continued support. Sunday SQL Developer Golden Gate Fun Run We had about 20 people show up – including a few crazies that ran up from the Hilton and back – and the weather was amazing. Yury…
Oracle Database Enterprise Edition customers have the option of extending their functionality set via various optional ‘packs.’ One of the most popular packs is the Oracle Diagnostics Pack. Funny, most people call it the ‘Diagnostic’ Pack, but it’s technically known as the Diagnostics Pack. Anyways, the pack includes a LOT of features. You can see all of them listed here. Now in previous versions of Oracle SQL Developer, we have exposed a few of these…