Oracle VM Consulting
view counter

App Development Feed

Oracle application development and Oracle database application development resources, news, and support articles.

If you haven't

If you haven't done so checkout the Oracle APEX universal theme packaged application on apex.oracle.com.  Here it is from inside a Tesla on a crisp 17" touchscreen.  Yes it does work while driving.

Migrating To Oracle Using Custom Object Names

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.

Say for example you have two tables called

  • Application_Name_SubArea_Name_SpecificAreaName_Table_Table1
  • Application_Name_SubArea_Name_SpecificAreaName_Table_Table2

apex.oracle.com has been upgraded to a pre-production version of Oracle APEX 5.0

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.

Update a grails project from version 2.3.8 to version 2.4.4

At first I changed the version of the application to 2.4.4.
> grails set-grails-version 2.4.4

The Secret Feature of Bucketsets in Oracle Business Rules

In Oracle Business Rules one can use so-called "Bucketsets". I never liked the term as it is not in the dictionary (did you mean bucketseat?), and never understood what is wrong with "list of values" (LoV) as that is what it is.

See for example the following bucketset that defines a list of values to be used for some status field:

Free Webinar: Getting Started with Oracle and .NET

Please join me on Wednesday, March 18th at 12 noon Eastern time for a one hour webinar going over the basics on how to get started developing C#/VB.NET apps for Oracle Database.

No signup needed. The Webex information is located here:

http://www.oracle.com/technetwork/database/application-development/appdev-webseries-2430444.html

Oracle Data Provider for .NET now on NuGet

ODP.NET, Managed Driver is now on NuGet, meaning that you can add ODP.NET to your Visual Studio project with just a few clicks in the NuGet Package Manager. We've also published an Oracle By Example walkthrough to take you step by step through the process of using NuGet and ODP.NET.

Created the first version of the JavaFX Browser inside Oracle Forms

I created the first version of the JavaFX browser inside Oracle Forms.

It still needs some adjustments, but the first version can be found at https://sites.google.com/site/oraont/jxbrowser-bean

Connections Types in SQLcl

We support many ways to connect in SQLcl, including lots from SQL*Plus which we need to support to make sure all your SQL*Plus scripts work exactly the same way using SQLcl as with SQL*Plus.

Code Insight on SQLcl

Here's a little preview of the code insight we have in SQLcl.  These changes are part of EA2 which are coming out very soon.  This also shows the buffer and cursor management which was introduced in SQLcl

view counter