We've been playing with our console drawing in SQLcl for a while now and this week, we hooked up some keys to make editing and running much easier. The video will show the following keys for managing your buffer in the console. This will make it into the next Early Access candidate soon.
Attention Chicago and Milwaukee area .NET developers: Please join me next month as I visit the Lake County .NET Users' Group and the Wisconsin .NET Users Group to speak to members on the topic "Oracle .NET and Visual Studio: Intro and Best Practices". Details below. Please be sure to sign up at the user group websites so they know you are coming and to find out about any last minute changes in time/location. Free food and drink will be provided.
It's been a month and a lot of bugs have been fixed in that time and new features added. That adds up to time for another EA for our new sqlcl. The third sqlcl EA is out now and can be found here on the SQL Developer 4.1 download page.
With enterprise manager for Oracle 11g R2, it seems there are endless ways to have it stop working. One excellent article that I used to get enterprise manager work again is found on oracle-base website. Here is the link
Sybase , SQL Server and other databases allow for long identifier names. Oracle allows for a maximum of 30 Bytes when naming objects like users, tables, ... When it comes to migrating objects to Oracle, SQL Developer will truncate the object names and resolve clashes with unique names.
If your an Oracle APEX developer you will want to try http://apex.oracle.com. We have just upgraded this free service to a close (but not yet) production version of Oracle APEX 5.0. If you already use apex.oracle.com login and validate your applications work as before. If you don't have an account create one; it should take about a minute.