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 give you the full power of the SQL interface to those bit bucket items – …
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 to simplify the SQL needed to access data. Analytic views layer a hierarchical/dimensional model over …
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 what you’d expect. You’ll also notice something new on startup/connects if you’re using a ‘local’ …
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 about this previously… …BUT, PL/SCope didn’t help me with tracking the SQL I used in …
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 running with Database 12c Release 2. And APEX 5.1. And ORDS 3.0.9. And of course …
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 too! I have: a 12.1.0.2 database the JSON patchset a table said table with IS …
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 start and end dates or …
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 ID text as JSON in …
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 columns to a table and …
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 we’re now seeing the SQL …
- Page 1 of 2
- 1
- 2