ThatJeffSmith

Tag: 12c

12c Temporal Validity Support in SQL Developer Data Modeler

Today’s question: can I design a table that takes advantage of the new Temporal Validity feature in Oracle Database 12c? Today’s answer: ‘Yes.’ In a nutshell: Temporal Validity Support lets you associate one or more valid time dimensions with a table and have data be visible depending on its time-based validity, as determined by the […]

Similar Posts by Subject Areas: , , ,

IS JSON or IS NOT JSON, That is VERY EASY to Figure Out

Working on some cool demos around JSON, ORDS, Oracle Database, JavaScript apps, etc. and I needed to load up a BUNCH of data to play with. Note the ‘other_tags’ column LOOKS like JavaScript Object Notation (JSON). There are JSON standards – should the key name and value strings be double or single quoted, etc. To […]

Similar Posts by Subject Areas: ,

Are Invisible Columns Really Invisible?

Today’s question: How are invisible columns treated with DESC, INFO and the GUI equivalent? Super quick, an INVISIBLE column is one that the user doesn’t see. They won’t be able to access it unless they know about it. Security by obscurity? No. Tom Kyte shows a few examples of the features usefulness, especially when adding […]

Similar Posts by Subject Areas: , , , , , ,

SQL Developer and a 12c Magic Trick

When you start working with 12c, if you want to freak out (sorry, GRAB the attention of) your co-workers or folks attending your presentation, try this: Open a worksheet Write a simple query against a view, or a data dictionary view Mouse over the SELECT and wait… Should just take a second or so… So […]

Similar Posts by Subject Areas: , , ,

Introducing the OTN Developer Day Database 12c VirtualBox Image

If you’re looking for an already configured Oracle Database 12c environment with a database already setup and all the software you need to learn database programming, design, and administration concepts, then look no further: This Stuff is all FREE The virtualization software is VirtualBox – that’s free. And it runs on any OS, including Windows, […]

Similar Posts by Subject Areas: , , ,

Defining 12c IDENTITY Columns in Oracle SQL Developer Data Modeler

You’re excited to see that defining triggers and sequences to populate identity columns in Oracle Database is no longer required. You have an Oracle Database 12c instance up and running, and you’re ready to hit the ground running. Wait, what is Jeff talking about? Ok, let’s say I have a ‘BEER’ table. My Primary Key […]

Similar Posts by Subject Areas: , , ,

Defining Redaction Policies for Oracle Database 12c Data Models in Oracle SQL Developer

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 […]

Similar Posts by Subject Areas: , , , ,

Oracle Database 12c By Example – SQL Developer and Multitenant

As you may have heard, Oracle Database 12c is now available. In addition to the binaries and docs going out, we also published a few new Oracle By Example (OBE) chapters. You can find those links here on our product page. Do you know who found these, practically the minute they were published? An enterprising […]

Related Posts Plugin for WordPress, Blogger...

Similar Posts by Subject Areas: , , ,