A new step-by-step tutorial shows youhow to deploy a standalone Java web application from Oracle Developer Cloud Service to Oracle Application Container Cloud Service.
Check out the steps for
- Creating a Project and a Git Repository in Oracle Developer Cloud Service
- Cloning the Oracle Developer Cloud Service Project Git Repository
- Building your Application on Oracle Developer Cloud Service
- Deploying your Application to Oracle Application Container Cloud Service
- Updating your Application
Try it out, get an Application Container Cloud Trial account.
The results helped contribute to a presentation I did Kscope15. Thank you to all those who responded. I thought I'd finally post some results, see if it can elicit further discussion, even of a casual nature.
Some of you asked me if I could post these results, so (more...)
I likened what I learned to Tom Kyte's essay (Asktom->Resources->Presentations->FalseKnowledge.htm) on Correlation vs Causation. The essence was that things change over time, and we can't always trust authorities on the topic, and we must always test in our own environments. This aligns with skepticism in general, and (more...)
Setting up an Oracle Wallet is quite straightforward, but it can be a bit of a hassle to configure a large number of certificates. Also, if you are using Oracle Express Edition (XE) which (more...)
This change can make a big impact in the execution time of PL/SQL as it's processed at compile time instead of interpreted at runtime.
Plug-ins can be wonderful black boxes and consumers may not care (more...)
Second, some SlideShare uploads (as promised):
- my talk about user-defined functions - that's where I was talking a lot about execution counts and the impact of Cost-Based Optimizer on them:
- updated version of my "Printing without Printers" talk. As usual, I (more...)
There's more to PL/SQL programs than packages, but most of our code will live in packages. The PL/SQL Reference offers the following benefits of organising our code into packages:
Modularity - we encapsulate logically related components into an easy to understand structure.
Easier Application Design - we can start with the interface in the package specification and code the implementation later.
Hidden Implementation (more...)
Sending emails from the Oracle database can be both simply deceptively braindead easy, and confoundingly perplexingly awful at the same time. Easy, because all you have to do is call one of the supplied mail packages to send an email:
UTL_MAIL.send (sender => 'email@example.com' ,recipients => 'firstname.lastname@example.org' ,subject => 'Test Subject' ,message => 'Test Message');
APEX_MAIL.send (p_from => 'email@example.com' ,p_to => 'firstname.lastname@example.org' ,p_subj => 'Test Subject' ,p_body => 'Test Message'
For most of our database set-ups we use a different TEMP space for application users than for end-user/support/developer/reporting usage.
The intention is to minimise the potential impact of a rogue ad-hoc query on the main applicaiton.
However, turns out this is ineffective IF you use:
ALTER SESSION SET CURRENT_SCHEMA = main_app_schema;
This is documented but I wasn’t previously aware.
No surprise that this learning opportunity was presented as a direct result of a rogue query (more...)
There are several new features in Oracle 12c that are implemented under the hood by changing the SQL statement that we write to a different statement (e.g., by adding some hidden predicates).
In OUG Ireland 2016 I talked about two such features – In Database Archiving and Temporal Validity – as part of my “Write Less (Code) with More (Oracle12c New Features)” presentation. I usually talk about another such feature in this presentation (more...)