The end goal for many users of Oracle SQL Developer Data Modeler is a a nicely formatted, easy to read diagram. Diagrams are composed of two primary components: Tables or Entities Relationships Today’s post is all about how to manage the display of the relationships. How can I move the lines around? You might not [...]
General
Managing Storage Properties for Multiple Tables in Oracle SQL Developer Data Modeler
There were more than a few questions I didn’t get a chance to answer in last week’s webcast with @ODTUG, ‘Data Modeling 101 with Oracle SQL Developer.’ If you’re a member of ODTUG, then you can watch or download the webcast. If you’re NOT a member, you can still sign up to attend KSCOPE13 in [...]
How to Hide Schema Notation from Tables in Oracle SQL Developer Data Modeler
Today’s question: Argh ! How can I remove the schema name from the relational diagram for a table in Sql Data Modeler ? Let’s take a quick look at the user’s source of frustration. I’ve previously reverse-engineered several Oracle schemas into a relational model in Oracle SQL Developer. HR and two other HR-Cloned users containing [...]
Oracle SQL Developer Quick Hit: Paren Matching
Today’s Question: Does anyone know of an editor (or program) that will match beginning and ending parentheses in sql and highlight an ending paren that is missing? It just so happens that I do know of such an amazing editor or program I’ll let the pictures do the talking for me this afternoon: Matched Parens [...]
Preserving Privilege Grants Whilst Editing Views in Oracle SQL Developer
Today’s Question: How do we prevent Oracle SSQL Developer from dropping the grants/privileges when modifying a view. While using SQL Developer we modified a view and once saved it removed all of the user access previously set up for the view. This did not previously take place when using… Ugh. That doesn’t sound good at [...]
Twitter
RSS
GooglePlus
Facebook