Friday, April 17, 2015

ODTUG Oracle Blogs - Now on Twitter

A while ago, ODTUG put a heavy emphasis on communities. As a result, 6 main communities were created: APEX, BI, EPM, Development, DBA, and ADF. Each of these communities have their own site dedicated to them along with a blog aggregator (click on each of their titles for the appropriate page).

The blogs contain an amazing amount of content from the entire Oracle community. The authors include Oracle ACE (Associates, ACEs, and Directors), Oracle employees, speakers from all the major conferences (including Kscope), book authors, etc.

Up until last week the only ways to take advantage of the blog aggregator were to go to the appropriate ODTUG community site or subscribe to the respective RSS feed. Starting today you can subscribe to the following Twitter accounts to get a message in your feed each time a new article is posted for your community.
Each tweet will also contain the community's appropriate hashtag. ODTUG has the complete hashtag listing here: If you're new to Twitter, following your appropriate hashtag can be a quick way to find some excellent and helpful content.

Some tweets will contain the author's Twitter handle (via a @mention). We're currently in the process of updating all the twitter handles for the authors in each community. If you write an article and don't see your Twitter handle show up, just reply to the appropriate Twitter account and we'll fix it.

As always, if you want to add your blog to the list, please email

Thanks to Adrian Png and Patrick Wolf for their ideas and patience getting this setup!

Monday, April 13, 2015

Installing SQLcl

SQLcl is the new command line tool from Oracle, more specifically from the SQL Developer team. It is currently an Early Adopter (EA) release and you can download it from:

After testing it for a while I was hooked and plan on using it as a full time replacement for SQL*Plus (which I think is the intent of the product).

The only difficulty I had was where to store it on OS X so it was accessible everywhere. Here's how I "installed" it and hopefully this will be useful for others:

cd ~/Downloads
#Note: version/filename of file will change for each release

#Assuming you already have an /oracle directory (I had one for the instant client)
cp -r sqlcl /oracle

#Give sqlcl execute permission
cd /oracle/sqlcl/bin
chmod 755 sql

#rename to sqlcl so no confusion (optional)
mv sql sqlcl

#Add directory to path so can run anywhere in the command line:

#Temporary access:

#Permanent access:
vi ~/.bash_profile
#Add just above the export PATH line

In the above example I installed SQLcl in the /oracle directory. You could also put it anywhere you want such as /usr/local/oracle etc. Just make sure that you reference the location in the PATH environment variable.

If you're looking for more info on SQLcl as well as some excellent examples check out Kris Rice's blog and Jeff Smith's blog.

Saturday, March 21, 2015

JS Console Wrapper Moved to GitHub

I recently received an email from Google Code stating that they will be shutting down their site early next year. Seeing as an JS Console Wrapper was hosted on there I have had to move it to GitHub:

They're some nice features in Console wrapper that integrate well with APEX however it was primarily created to get around the lack of support for Console in IE. Since the newer versions of IE now support Console, Console Wrapper may no longer be necessary.

If you do use Console Wrapper and would like to see it be improve please create an issue on the project page.

Tuesday, March 17, 2015

Logger 3.0.0 EA1

In case you missed yesterday's announcement from OraOpenSource, Logger 3.0.0 EA1 was released yesterday. If you're using Logger you definitely want to read the article and learn about all the major updates to Logger. If you're not using Logger, now may be a good time to take a look and see how it can help your organization.

Wednesday, March 4, 2015

Logger is Moving

I'm pleased to announce that Logger has found a new home and will be maintained by OraOpenSource. A very big thank you goes out to Tyler Muth for starting this project many years ago and handing over the reins to OraOpenSource.

Here's a brief FAQ regarding the move:

What is Logger?

Logger is a (free) open source logging tool for Oracle PL/SQL. It is used in many instances ranging from small applications to very large applications in major corporations.

What will happen with links to the old project page?

They'll still work. The project was forked and a notice was put up on the old Github site letting people know its new home.

Will Logger still remain open source / free? 

Yes. We'll update the license slightly so that it will be easier to understand and use within your code. This will not affect any existing implementations.

When is the next release?

I did a lot of work last year, then was sidelined with my concussion. It turns out that picking up a project after not touching it for 8 months takes some time.

Since I'm working on this project as part of my rehab I can not give a definite time frame. As soon as the beta version is ready I'll make it available.

What is in the next release?

Lots of great stuff! Going forward you can monitor what will be in each subsequent release by tracking the upcoming milestones on the project's issue page.

Will you still post info on Logger on this site?

Over the years I have written a lot about Logger and posted it on this blog. To maintain a consistent branding and marketing effort all future posts regarding Logger will be on OraOpenSource's blog.

What can I do to help?

Right now the best thing you can do is sign up for the email list (link on We'll be announcing the beta version and next major release when it's available. You can also follow OraOpenSource on twitter: @oraopensource.

Once the next release is available we'll be looking for help from the community to continue to develop and maintain Logger.