Oracle VM Site Review - Oracle VM Health Check
view counter

App Development Feed

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

Repeating another SQLCL EA release

    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.  

  Not sure what this sqlcl thing is ? Check here.

LOAD:  Making CSV loading to the db very easy

Here's a very quick example of the possibilities.

Enterprise manager woes and a solution

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 

Moved Forms PJC examples to GitHub

I moved my Forms PJC examples to GitHub. The examples and the Oracle JDeveloper projects can now be found at: https://github.com/mark-oradev/FormsPJC

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.
view counter