Category: General

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: ,

SQLcl: Using the new CTAS Command

How often do you need to build a new table to test something out? How often have you typed CREATE TABLE AS SELECT… If the answer to both of those question is ‘quite a bit Jeff!,’ then continue reading. In SQLcl, we have built a new command simply called ‘CTAS.’ So let’s try it out. […]

Similar Posts by Subject Areas: , ,

I’m On Vacation – Go Read These Blogs Instead

I’m at the beach! But if you desire fresh SQL Developer-themed content, then you are still in great shape. Check out these blogs: The Data Warrior AKA Oracle ACE Director Kent Graziano Heli from Finland AKA Oracle ACE Director and published author Heli Helskyaho Kris Rice Colm Divilly Barry McGillin Not Enough? I have a […]

Similar Posts by Subject Areas: , , ,

Your Most Requested SQL Developer Demos

The team just got back from another Oracle User Group Conference, or I should say THE conference. I know most of you don’t get to go to conferences. Or have nice computers. Or use foreign keys. Or have nice things. BUT. One thing you do get to have today, is the same popular Oracle SQL […]

Similar Posts by Subject Areas: , , ,

Connection Filtering Across all Schema Objects

Most folks know they can filter their list of Tables. But did you know you can set a global filter across your entire connection? It’s pretty basic, but also pretty powerful: So how would this be useful? Maybe for your project or program module, you have all of the objects starting with the same prefix. […]

Similar Posts by Subject Areas: , ,

If you only get one SQL Developer ‘trick,’ make sure it’s this one.

I had a fun conversation with @tmuth today: I attempted to distill my entire tips & tricks ‘sermon’ down to a single suggestion. For productivity, I suggest every user get comfortable with Document Tab Groups. So if you want to work on a stored procedure while you browse a table, right click on your document […]

Related Posts Plugin for WordPress, Blogger...

Similar Posts by Subject Areas: , , ,