Having an extra bit bucket in your tables is pretty easy now in Oracle Database 12c and higher. We offer native JSON support [JSON DOCS] – you can have a free form text column and store anything you want in it. AND, we pretty much …
Oracle Database 12c Release 2: Analytic Views & SQL Developer
One of the major new features in Oracle Database 12c Release 2 is Analytic Views. An analytic view is a type of view that can be used to easily extend the content of a star schema with aggregated data, measure calculations and descriptive metadata, and …
Updated SQLcl: 2 New Commands, Bug Fixes, and 12cR2 Oh My!
You have a new version of SQLcl to download this morning. Lots and lots of bug fixes – again, thanks everyone in the community for providing feedback so we can make continuous improvements. A few things of note: Two New Commands They do pretty much …
PL/Scope in Oracle Database 12c Release 2 and Oracle SQL Developer
PL/Scope is one of my favorite features. It answers SO many questions. Where am I declaring this, where am I calling that, when am I referencing something? And, I can get this information automatically, without hitting the big, fat SOURCE data dictionary views. I’ve talked …
Oracle Database 12c Release 2 is Now Available…and so is our New VirtualBox Appliance!
Want to get started on learning everything there is to know about the latest version of our Database? Don’t want to really have to install or create anything? Well, you’re in luck. Just go download our image. In a few minutes, you’ll be up and …
Quick JSON Query Tip: Use Column Aliases for Arrays of Objects
This isn’t a SQL Developer post, sorry folks. When it takes me more than a couple of Google searches and more than a little bit of poking around to figure something out, I reckon it’s blog-post-worthy. Maybe I can save you a bit of time …
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 …
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 …
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 …
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 …
- Page 1 of 2
- 1
- 2