The ability to deploy Java inside the Oracle database led somebody to conclude that the source isn’t visible in the data catalog. Then, that person found that they were wrong because the Java source is visible when you use a DDL command to
COMPILE the Java source. This post discloses how to find the Java source and how to prevent it from being stored in the data catalog.
For example, (more...)
Photo by Nate Whitehill
It’s been a few weeks since I returned from another awesome Kscope conference and I just realized that I never wrote about it.
For me, it was the first time visiting Seattle and I really liked it even when I only managed to walk around the downtown area. I had some concerns about how the weather was going to be but everything worked out very well with clear skies, temperature in (more...)
Observing tourists around me, I’ve noticed that the regular selfie doesn’t cut it anymore. The essential travel accessory for the modern self-absorbed traveller is a selfie stick:
Of course, the whole selfie concept is the opposite of a traditional tourist snapshot: Not “see what I saw,” but “see me”. But while you are at it, why not make yourself a spectacle while you take the picture. Hence, the selfie stick.
The picture is pretty much (more...)
This was just a proof-of-concept, not something I intend to actually leave running.
EPG on Port 8080
I do other testing on the home network too, so I already had my router configured to forward port 80 to another environment. That meant the router's web admin had been shifted to port 8080, and it wouldn't let (more...)
The basic example stems from the need to order data that might contain characters.
with data as
(select '1' vc from dual union all
select '11' vc from dual union all
select '2' vc from dual union all
select 'a' (more...)
select distinct deptno,dname from dept join emp using(deptno)
In this blog post, I am going to look at how the APEX_JSON package can be used to generate JSON from data in your database using PL/SQL.
There are multiple ways of creating JSON output using the APEX_JSON package. There are several overloaded write() procedures which can output (more...)
So as always we begin with the basics, be sure to checkout the AuraPlayer family photo album of all of you who joined us for a toast throughout Kscope14. My Kscope in pictures.
You can revisit the slides from my sessions here:
Bring Your Legacy Applications to the Mobile World : Tips and tricks on how to begin your Mobile journey.
Experts Panel: Should I Migrate My Oracle Forms Applications? Experts Panel that addressed the future (more...)
The solution is relatively simple, and I thought I'd write it up here for a place to copy syntax each time.
APEX users also have a handy table to verify this against (apex_application_files). Well, a synonym/view that ultimately maps to the core table wwv_flow_file_objects$.
It contains a doc_size column, which is no doubt evaluated at some point during upload of (more...)
If I’m going to wear something like that on my wrist, I need a really compelling usecase. I’m not sure that getting even more notifications and reacting 0.8 seconds faster is what I’m looking for.
When my latest Nike FuelBand eventually dies (they seem to last about (more...)