You may not spend a lot of time creating tables in your database, but if you are performing that task, you don’t want your tool to slow you down. And while many of you may design your tables in a modeling solution or even code them by hand in a worksheet, there are still some of you out there that are using our Create and Alter dialogs. And that’s what I’m here to talk about…
I recently talked about how you could tell the modeler to use custom classification types for your tables. But, I forgot to tell you where you could find these settings in version 4! Surprise – we moved them. Excellent… Sometimes I think developers change stuff because they’re bored or maybe even because they don’t realize even the smallest change can create lots of angst for the end users. However, in this case the changes were…
We recently covered how to set the classification type of multiple tables in a data model, but today I want to show how to make these easier to identify in your model. I’m also going to show you how to set multiple classification types for a single table – a new feature in v4 of the Modeler. By default, the supplied classification types are assigned a color scheme: If you need more classification types, you…
The new editor framework provides a more interactive and rich experience when replacing text. It’s a very simple improvement, but one that I think will make you feel ‘better.’ I know that’s a subjective measurement, but I’m sticking with it. And something I talked about earlier, double-clicking on a ‘word’ in the editor will auto-find and highlight all occurrences of that text. This is then automatically used as the basis of a search and replace…
Someone asked me how to model a table as an IOT in Oracle SQL Developer Data Modeler. But before I answer that question, we shoudld spend at least a second on just what an IOT is. It’s an ‘Index Organized Table.’ The storage is organized by the index, versus say the default behavior of a heap structure. Or as the docs put it: index_org_table_clause Use the index_org_table_clause to create an index-organized table. Oracle Database maintains…
Oracle SQL Developer Data Modeler version 4 was released as an Early Adopter just last week. You can go download it here and read about the new features here. A snippet of those new feature release notes… Masking Mask templates can be defined and used in definition of columns with sensitive information. Support for REDACTION policy definition on table and column level. Support for Transparent Sensitive Data Protection (TSDP) policies: Sensitive types can be created…
One of our more popular features is ‘DB Doc.’ It’s like JAVADOC for the database. Pick a connection, right-click, and go. It will generate an HTML documentation set for that schema. For version 4, we’ve introduced a few enhancements based on user requests. That’s right, you asked, and we listened. Added support for Package Bodies Added parallelization option for larger doc sets Enhanced the HTML formatting a bit Select Your Object Types and Generation Options…
You may have noticed a few posts lately where I’m talking about new and improved features in SQL Developer version 4.0. You may have also been too busy to read all of them. For shame! But that’s OK. I’ll be doing a webcast with ODTUG on Tuesday, August 20 at NOON Eastern Time. When I’m asked to describe ODTUG, I go with “Well, ODTUG used to stand for ‘Oracle Developer Tools User Group’, but it’s…
One of the cooler features SQL Developer offers is the ‘split document.’ If you don’t know what I’m talking about, please take 90 seconds and read this short post first. Ok, well that worked well for pretty much every type of editor in SQL Developer save one – the SQL Worksheet. Let’s say you wanted more ‘type and read’ space for your script or statement, but you also didn’t want to lose your results grid…
This feature is going to be hard to cover in a single post, but I’m going to try anyway. The Reports interface received performance improvements, a few tweaks to make them easier to build, a slew of new charting options, and more visual control to tweak. Oh, it’s also available via the command-line interface. Let’s cover the performance bit first. The first time I try to open a report in ‘Edit’ mode in earlier versions,…