Category: Database Stuff

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

Generating Table DDL via SQLcl, with and without Storage Clauses

We’re getting much closer to having Oracle SQL Developer version 4.1 ready for release – which includes SQLcl, our new command-line interface for Oracle Database. Just a quick reminder in case you’re too lazy to click to that other post: We’ve taken our existing Java based SQL*Plus script engine from SQL Developer, and built a […]

Similar Posts by Subject Areas: , , ,

Quick Hit: Number of Rows Returned By a Query

Question: How can I make SQL Developer display the number of rows returned by a query? Answer: Execute the query, and fetch all the rows. But I’m not seeing it! and fetch all the rows. This part is important. Execution using ctrl+enter executes statement, and returns the FIRST ‘fetch’, by default of 50 records. First […]

Similar Posts by Subject Areas: , , , ,

More Fun with Data Modeler Diagrams

Everyone likes pictures. Generate a report without any pictures, graphs, or charts and see how many ‘likes’ you get at work. Everyone gets excited about data modeling, and in some circles, folks think that data models are synonymous with diagrams. But really, the diagram is just the ‘pretty picture’ you add to your office report. […]

Similar Posts by Subject Areas: , , , , ,

Exporting SQL Developer Reports/Grids to PDF

You can save query results or any other grid in SQL Developer as a PDF. You don’t get much in terms of saying how the generated PDF should look – Said PDF file: But I have some important info in here, and it should look a bit nicer. Save Your Query As A Report And […]

Similar Posts by Subject Areas: , ,

On Installs and Updates of SQL Developer

As we get nearer to releasing our next update for Oracle SQL Developer, there are a few FAQ’s I’d like to answer. When IS version 4.1 going to be available? Soon. Right NOW, actually. Will there be a Windows download available that includes a JDK? Not today, but there will be a 64-bit bundle available […]

Related Posts Plugin for WordPress, Blogger...

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