ThatJeffSmith

OT: Bad Tools Lead to Overly Verbose Code?

For some reason I decided to re-join a discussion in the SQL community from way back in 2012. THIS => "tbl_ is a tell for bad database design" via @datachick http://t.co/hq2BH73xic sorry @SQLRockstar — Jeff Smith (@thatjeffsmith) May 28, 2015 Karen started it, Thomas ran with it, and I decided I had to throw my […]

Similar Posts by Subject Areas: , , ,

SQL Developer Data Modeler, Pending Changes & Versioning

Oracle SQL Developer Data Modeler supports the one-gal design boutique shoppe and the mega-huge development team. It HAS a file-based repository (Subversion aka SVN.) You don’t have to use it, but you should. You can optionally store your designs and data dictionaries in a database for reporting purposes. I strongly recommend you do so. If […]

Similar Posts by Subject Areas: , , , ,

SQL Developer version 4.1 Feature Recap

We’ve been working on version 4.1 since last Fall, and I’ve been blogging about the new stuff all the while. In case you missed it, we officailly released version 4.1 yesterday Here’s a quick index of all of those version 4.1 posts you may have missed: SET SQLFORMAT command and a new formatter, JSON a […]

Similar Posts by Subject Areas: ,

Oracle SQL Developer version 4.1 is Now Available

Oracle SQL Developer version 4.1 is now available. So is SQL Developer Database Modeler version 4.1. And so is Oracle REST Data Services version 3.0. Java Requirements For SQL Developer Java 8 is now supported. It’s also required. If you need to, you can install Java 8 without removing Java 7 and ‘breaking’ your other […]

Similar Posts by Subject Areas: , , , ,

A Quick Hit on Database Auditing Support

View – DBA – Security – Auditing A user asked how to use SQL Developer to audit user XYZ. And to be honest, it’s not really set up to work that way. You define operations or objects you want audited. Any user that does XYZ to object ABC will get logged. There’s an exception to […]

Similar Posts by Subject Areas: , ,

Tailing the Alert Log with SQLcl

Hopefully you’ve heard about the new SQL*Plus we’re building. And hopefully you’ve heard about the new REPEAT command we put into it yesterday. Here’s a quick example of how to build a little ‘monitor’ in just 2 commands, a total of 5 lines of code. The SQL SELECT To_Char(Originating_Timestamp, ‘DD-MON-YYYY HH24:MI:SSxFF’) Time_Entry, substr(message_text, 0, 75) […]

Similar Posts by Subject Areas: , , , ,

SQLcl: Run a Query Over and Over, Refresh the Screen

I was going to talk about our new IMPORT command in SQLcl. This will allow you to feed a delimited text file of data to our command line interface and have it automatically imported to a table. But Kris Rice beat me to it. Woo-hoo, less work for me So go read that now. If […]

Related Posts Plugin for WordPress, Blogger...

Similar Posts by Subject Areas: , , ,