Kris' blog

SQL Developer 3.1 and Obfuscation

2012-02-08T14:47:00.000-08:00

SQL Developer 3.1 , SQL Developer Datamodeler 3.1, and the OTN DB VM were all released yesterday. Now it's time to blog about some of the new features included in these releases. Be sure to check out the various blogs the team has. There's a listing on OTN here. First up from me is PL/SQL Obfuscation. The idea is to simply make the code unreadable. This is done in various language mostly

OTN Tech casts related to the DB VM image

2011-11-01T19:26:00.000-07:00

There's going to be a pointer in the next version of the Database VM Image to some OTN Tech Casts. This is list is from Todd in the OTN Team which anyone who knows Todd means this is no-nonsense straight with development. I thought I should pass it along. Here's the note from Todd: A lot of different technologies and work has gone into the creation of this Database App Development VirtualBox

Schema Diff - Part 2

2011-10-14T14:15:00.000-07:00

After showing the new Schema Diff in SQL Developer 3.1 @ddelmoli asked about separate files per object diff instead of the monolith file of all changes. In the next EA when it comes out, you'll get prompted for what kind of file(s) to make if any at all. There's several new options 1. Single File - what's there now, 1 file with everything Along with the 1 file per object is a generated

SQL Developer 3.1 EA1 - Drill Down Report

2011-10-11T17:15:00.000-07:00

I got a question on twitter from @goryunov about how to do drill down reports. I plan on doing a few posts on reports since so much of the dialogs have changed. That make this the first of a few blogs on reports. Step 1. Right click on the User Defined Reports and choose New Report Step 2. Create a "Departments" report by naming it and entering the SQL. This dialog has drastically changed

SQL Developer 3.1 EA1 - Schema Diff

2011-10-10T15:38:00.000-07:00

It was great showing everyone last week at OOW what was coming. The only thing better is giving people the software to start using. Now that it's out, I'll do some blogging to get some of the new areas pointed out. One of the major areas of work in SQL Developer 3.1 is the diff generation between 2 schemas. This is completely rewritten from the ground up. That's interesting but maybe more

Oracle Express Edition 11.2 is here!

2011-09-01T16:31:00.000-07:00

Oracle XE 11.2 is now available on Windows 32 and Linux 64. It can be downloaded here. I'll be shortly putting together another VirtualBox image so it can be used on other platforms. This is also a great database to try out the Learning Library labs on. In case anyone doesn't know, Oracle Express Edition is the free database. The limitation has gone up to 11.

3 Upcoming OTN Developer Days

2011-08-31T15:15:00.000-07:00

There's a few more of the OTN Database Developer Day free training events coming up. The first is next week in Reston,VA. This is the full four track event. If you are able to make it, it's a great chance to talk to some of the development staff that run the event. Mike Hichwa will be giving the keynote. The agenda for this even can be found here: http://www.oracle.com/us/dm/h2fy11/77471-

Apex Listener + WLS + Serving static files from /i/

2011-07-21T16:08:00.000-07:00

A common thing that people ask about is setting up the images directory in weblogic. The documentation explains how to generate an i.war file then deploy it. This work great until the need arises to also host additional files like custom javascript or css. This is a short video of how I setup the /i/ for my servers. This setup lets any content in the directory be served out. The one

New and Improved!

2011-04-15T10:08:00.000-07:00

The SQL Developer Exchange , http://sqldeveloper.oracle.com, has been out there almost since the beginning of the tool. It's our way to allow users to log requests and have other vote on them. Then we each release pick off some and put them into the product. It's been basically unchanged since day 1. This week I've built a new set of screens which hopefully look better and are easier to

SQL Developer 3.0, XE 11.2 Beta, Developer Days

2011-04-01T11:41:00.000-07:00

It is said things happen in threes. 1) SQL Developer 3.0 was release on Tuesday. Some of the major new/revamped things include migration from Sybase, Data Miner, Spatial, and Scheduler. There's a longer list of new things we added which can be read here. If you have not already, it's downloadable here. 2) OTN Developer Days in Toronto. We had a great crowd in Toronto. Chicago is

PL/SQL Unit testing in the builds

2011-03-16T16:28:00.000-07:00

At the OTN Dev Day in Dallas last week, I asked how many people unit tested PL/SQL. The response was a kind of group chuckle acknowledging it should be done but isn't being done. This was not really surprising since it's the same response I get everywhere I ask. The difference is that in this event the attendees did a hands on lab and made tests. The exact same lab that is in the Oracle

OTN Developer Day VM March '11 Edition

2011-03-08T16:44:00.000-08:00

The Database VM was just updated. You can get it here: http://www.oracle.com/technetwork/database/enterprise-edition/databaseappdev-vm-161299.html Quick reminder that this VM is only-a-sandbox. All passwords are oracle, for that an other reasons this is never to be used for any purposed other than a sandbox. The main changes in this VM are: - New OBEs! - Upgraded DB to 11.2.0.2 - SQL

Application Express Views - Key discovery part 2

2011-02-03T14:42:00.000-08:00

Yesterday, I showed how the new Foreign Key discovery works on a subset of dba views. The only catch was that the end result had T_DBA_ prefixes for the names. It's really easy to change that. Once you import the views and convert them to tables, delete the views. What you are left with is a bunch of tables prefixed with T_ . Now right click on the relational model in the tree and choose

Data Dictionary Posters and Automatic FK discovery

2011-02-02T16:49:00.000-08:00

We have all had posters on the wall at some point that are the data dictionary. That is if you made it to the booths before they ran out at Oracle Open World or other events. There's a few new features in the FREE Oracle SQL Developer Data Modeler that went production this week that can help avoid the need for the posters. First we have to import from the data dictionary, the data

Modeler Custom Transformations

2010-12-16T14:02:00.000-08:00

This is a follow up to the transformation I mentioned earlier where I mentioned how to write custom transformation in javascript for the design. This is based on a java's pluggable script which means almost anything can be plugged in instead of javascript. See here for details on the available languages. This is the beginning of what I plan on building up over time which is a library of

APEX Listener startup/shutdown script

2010-12-10T11:56:00.000-08:00

David asked me for a way to keep the listener up and running when a box is rebooted. There may very well be better ways to do this but this script can be used to start, stop, get status, and tail the log file. Also it can be dropped in as an init.d script to have the Listener start when the box starts. Since we don't have access to init.d for David's case, we are just going to put in a cron

Adding mail processing to your database app

2010-11-11T15:07:00.000-08:00

I'm not sure how many people know that part of the APEX team, Sharon Kennedy, runs ProMedmail which is probably one of the scariest and most active internet APEX applications. It is "The global electronic reporting system for outbreaks of emerging infectious diseases & toxins, open to all sources." So by a scary APEX app I mean you can get your latest updates on Anthrax in Bangladesh,

Fine Tuning SQL Developer

2010-10-27T13:18:00.000-07:00

Someone recently told me they didn't know you could turn off extensions you don't use in sqldev so I thought a quick blog may be in order. Since SQL Developer and jDeveloper are based on the concept of extensions, they can do things like check for updates or install new extensions very easily. The other side of that is that you can disable the extensions you don't use. A couple example of

Apex Listener EA and more

2010-10-20T10:48:00.000-07:00

In case anyone missed it, the new APEX Listener 1.1 EA is out. The big new feature in there is the Resource Templates. If you are interested in this feature and have not found it yet, you should really start following Colm's blog. You can learn about it from Colm: here and my post last week: here. It will let you get data out via REST with less development than ever before. The Developer's

Four Stages of Learning

2010-10-19T13:54:00.000-07:00

I went to a great set of classes this weekend and wanted to share one of the things I learned. The classes had nothing at all to do with any form of technology, it was to get a hockey coaching license. It was a very fun class since we got to meet Jamie Baker and Jay Woodcroft . One slide was on the four stages of competence. I don't think I've seen this before but it's on wikipedia and

SQL Developer 3.0 and Encrypted PDF

2010-10-14T13:55:00.000-07:00

Another new thing in the EA is unloading the grid of data to a pdf file. Plain PDF is one thing but what this will show is how to encrypt it. While in the database the data is normally quite secure and you have to have proper permissions and knowledge on how to get to the data. However, when it's loaded into excel or PDF or ... the security is far harder to enforce. Here's one way to address

SQL Developer 3.0 EA

2010-10-13T08:57:00.000-07:00

Monday we released the SQL Developer Datamodeler 3.0 EA . Today the SQL Developer 3.0 EA is out. There's lots of new things in this version. Here's a quick index to some of the larger features that have been added. There are also too many smaller things to list which include things like a Table API generator. Some of the features have online demos already more are on the way. I will continue

SQLDeveloper Datamodeler 3.0 EA

2010-10-11T16:29:00.000-07:00

In case anyone missed it this morning, there's an Early Adopter build of the Modeler released today. You can go and download it from the normal place on Oracle.com http://www.oracle.com/technetwork/developer-tools/datamodeler/overview/index.html There's been some great new features added to this release and Sue has some webcasts which range from an overview to more detailed webcasts on

3.0 Modeler Sneak Peak - Transformations

2010-10-09T11:59:00.000-07:00

The newly free modeler has some great new features coming as well. This is an example of the new scriptable transformations. This is a fairly simple example but I think it shows of how powerful this form of transforming the models can be. First, we start by importing the HR schema to have something to work with. To invoke a Transformation or create a new one, simply choose under

3.0 Sneak Peek #2 - Schema Browser

2010-10-09T08:00:00.000-07:00

I'm going to try and do some short blog entries that are showcasing some of the up and coming features of 3.0. We showed lots of people at Open World but for those of you that couldn't be there, stay tuned and I'll put a few things out. Another new thing being added is an alternative view of the objects in the schema. Simply right click on the connections and choose Schema Browser.