I’m doing a talk on this very subject next week at ODTUG’s KScope14 conference, and I’ll put up the slides on Slideshare after the show, but I wanted to give a quick shout-out to the things you COULD Be using today to get the most out of your models and design experience. Search SubViews Reports Preferred Data Types Propagating Properties DDL Previews Drag ‘n’ Drop Tables from SQL Developer Tree Transformations Navigating Diagrams Design Collaboration…
Sometimes you need more memory. Here’s an example: you want to model a database that has 1500 tables in it. What would that even look like? If you zoom out far enough… Now, ‘large’ is a subjective term. But lets put it this way – if you’re dealing with more than several hundred tables or entities – that’s larger than most other designs. Oracle SQL Developer Data Modeler, and the modeling extension that runs inside…
There’s a nasty rumor going around that you can’t compare database objects and/or code in Oracle SQL Developer. So let’s put that to bed right now. First, here’s how to compare: PL/SQL to PL/SQL or a SQL statement to another SQL statement So now that that’s settled, why don’t we take a look at how to compare a single table, to another table – whether it’s in the same database or a different database. Database…
Tnsnames.ora [DOCS] is a configuration file for SQL*Net that describes the network service names for the databases in your organization. Basically, it tells Oracle applications how to find your databases. This post is just a quick overview on how to get SQL Developer to ‘see’ this file and define a connection. There’s only a single prerequisite for having SQL Developer setup such that it can use TNSNAMES to connect: You have somewhere a tnsnames.ora file…
Running queries, browsing tables – you are often faced with many thousands, if not millions, of rows. Most people are happy with looking at the first few rows. But occasionally you need to see more. SQL Developer doesn’t show you all records, all at once. Instead, it brings the records down in ‘chunks,’ or as-needed. How It Works There is a preference that tells SQL Developer how many records to get in a single request,…
So you just got your brand new machine at work. Party time, excellent*! Amazon.com Widgets And, your friendly neighborhood IT guy even moved over all of your softwares, including SQL Developer. But when you go to use it, none of your connections are there. Or maybe the connections are there, but the connection passwords ARE not. And really, who has the discipline to have 300 different passwords for all of the databases memorized and ready…
150 of my closest friends, or some random people on the Internet, joined me today while we talked all about SQL Developer’s reporting feature. Did you miss it? If so, I’m guessing you’re not a member of ODTUG. They put on free webcasts for everyone in the Oracle technology space. If you’re a member, you also get access to the recorded sessions in their archives. You can monitor their Webinar page, OR follow them on-line…
I said earlier today that version 4.0.2 of SQL Developer consisted on ONLY bug fixes. I should have said MOSTLY bug fixes. There was also one minor tweak, although it was a minor tweak to a major feature: Completion Insight. This is the feature that kicks in while you are typing – suggesting column or table names to help you complete your SQL statements in an editor. Watch this quick video to see it in…
A customer wanted to know how they could quickly see what tables were in one database, but not in another. They don’t want to run a DIFF, they just want to click-click-click-BAM! So, we want to go from here: to here: Here’s what I’m doing: Open A Schema Browser Float it Repeat as desired And this is why I love doing customer sessions. I haven’t been asked this question, ever. But today, a very fun…
Sometimes while I’m demonstrating Oracle SQL Developer, something on the screen catches the eye of someone in the audience, and they just have to know ‘what is that?’ So I put together the image you see above with a few key features highlighted. These might be things you’ve missed because they’re not default preferences or because you’ve ‘missed’ the right-click mouse operation to activate it. Here’s the list, can you match it to the highlighted…