Tuesday, June 16, 2015

I'll Be Done and Broke...

Before a Machine Takes My Place

This is a real sentiment told in the form of a tall tale.  Not many believed it, but there's a story behind in deified disguise.

Why'd you choose Socrates?  I thought it was supposed to be Solomon?

Socrates from the Greek Civilization brings knowledge of the Oracle with Delphi, given you have a compatible OS at your system. (Either or both)

Well, you get both.  Now explain that this won't fly without an additional blessing...

For your team, you have the option to go Solo, mon.  One display? OK.

Mr. Henry?  Do you expect any backlash from the alternative quote from your heroic statement?

Commander Rainbow Cupcake is finshed baking.  The Lieutenant is also here.  Can you explain why we're working next door to the galley?

Congratulations, you've obtained the command line.
There is only one 'tenant, so you'll be stationed on the grid.  Internet enabled features are also at your side. (ref. 8i, 9i, 10g, 11g).

More Java?
Less please.

And why do you choose the pink calculator for your assist?


You mean this challenge instance?

Instance?  You mean there's more than this?
I think so.  Check with the Commander and the Lieutenant.  They have more cupcakes where the first ones came from.  Have a bite.  It's lunch time.

Monday, June 15, 2015

Sequenced and Ready to Identify

Study Group with DB Developer

What does a developer with databases want with a role handling sequences?  Just a play one would word to get this story straight:  things you thought you knew about databases are worth a rethink.  Things that make you go hmmm...

See the Google Plus site for the mini challenges.  Come back here to get another perspective as a coder of SQL.  Have a great evening everyone.  Keep watch on the Connection for more this week.

Saturday, June 13, 2015

Oracle Application Express (APEX) Updates

New APEX Release is Here

Just a few months ago, Oracle released its latest update to the Application Express product.  Here's a look at what is new for Release

This is a descriptive detail of some things application express can do.
Features of Oracle APEX 5.0

Prior to this, an update known as the "Oracle Standalone Listener" client made it possible to build an Apex appliance for serving out Application pages and services (API's, web pages, and forms) as an external module from the database hosting the Apex instance. 

If your server resources are not many, you can still install or configure the APEX listener to run on the same server/virtual machine as the database, but now a farm of specialized listeners can also be stood up (behind a load balancer or some appropriate network scaling design) to fit the system's chosen uses.

I drew up this sketch of the relation between a database instance and the supporting schemas it contains. An Apex module layout is the relation between individual Apex applications, workspaces and the database schemas they can connect to.

This diagram describes how the database schemas, objects and resources are arranged.
Oracle Application Express SCHEMA

The version of Apex is not tied to a specific release of the Oracle database, although to install the package associated with this module, your database must be at least Release 9i or higher.  See my profile on Stack Overflow for additional discussions on my findings and interactions with developers regarding the APEX product.


Here's a look at a past Stack Overflow post I did on BLOB (Large Object) handling between an APEX application form input and the database:

How to set up the APEX table, form and report to accomplish this task.
File Attachments Handled With FORM INPUT and OUTPUT Requests

That's it for now!