OraNA :: Oracle News Aggregator

Recently I blogged about a nifty CSS only menu that is a great alternative to the horrible APEX tab-sets. Unfortunately I had to ditch it for a recent project because it didn't work well on touch screen devices, so I picked up Enkitec's Navbar plugin instead.

I wanted to freeze (more...)

You may have noticed that when you have a new installation of  reports 11.1.2.0 when you try to run a PDF report or even if you simply try to do a  showjobs request you get the error REP-52262 Diagnostic output is disabled. It seems that in a (more...)

Here is a short story about a little problem that caused me a bit of grief; but in the end had a simple cause and a simple fix.

I had a dynamic action in my Apex 4.1 app that had to run some PL/SQL – which was working fine, (more...)

Martin D’Souza:

Logger is a PL/SQL logging and debugging framework. It’s used in many organizations to instrument code in their Oracle applications. Tyler Muth created Logger a few years ago and has since released several upgrades, the last being 1.4.0. After some great feedback, I’m pleased to announce (more...)

drop procedure is_not_really_gone_but;

select object_name || ' ' || object_type 
                 as "Continues on"
from   user_objects_ae
where  object_name = 
           'IS_NOT_REALLY_GONE_BUT';

Continues on
-----------------------------------
IS_NOT_REALLY_GONE_BUT NON-EXISTENT

create table is_not_really_gone_but ( 
  until_replaced            number,
  by_a_non_editioned_object varchar2(1) 
                            default 'Y',
  which_we_then_drop        varchar2(1)
);

drop table is_not_really_gone_but;

select  (more...)

Warning:  While this appears to work, I do not know if the behavior is defined.

It seems that using a scalar subquery in the select list of an updatable view allows us to return the old value of a column.  I’ll update this post with more details when I (more...)

Tom is not not a fan of public synonyms, here is why:

• public synonyms pollute the namespace.
• public synonyms can lead to security issues.
• public synonyms can lead to a maintenance headache.
• public synonyms are public – no one owns them.

So, instead of public synonyms…

create PRIVATE synonyms or (more...)

The basic idea behind the Exadata Hybrid Columnar Compression (hereby referred as EHCC) is to reprise the benefits of column based storage while sustaining to the fundamental row based storage principle of Oracle database. Oftentimes  the databases following column based storage claim that comparatively they needs less IO to retrieve (more...)

Have you responded yet to PyOhio's Call For Proposals (due date: June 1)? You should. Here's why.

Why you should speak at PyOhio

We need you. We have a great group of people who contribute talks, but we don't ever want that group to become a stagnant pool - we (more...)

For my newest ipython-sql trick, I needed to compare some queries run across different databases. How hard would it be to get side-by-side results into tidy IPython Notebook output?

Not hard at all, it turns out, if you're willing to violate basic principles of human decency.

That's an itty-bitty image, (more...)

delete
from   roads
where  cars in ('my', 'way')
and    desire_to_get_home_quickly = 'huge';

1,492 rows deleted
Now I just need to find a way to execute this before leaving work to ensure an smooth flowing journey home!

Running lots of scripts in SQL*Plus is nice when they are working correctly. But what about when they fail?  Its a pain to figure out what went wrong, unless you have a log file and even then, you have to hunt the errors down.

Well, I've had enough of that. (more...)

When you have a load of SQL*Plus scripts, they can be a pain to manage and just simply get around.
In the next version of SQL Developer, you'll be able to hold the ctrl key down and click on the file name and have it open up.  This also works (more...)

So you haven’t decided if you should go to Kscope13. I’ll give you 5 reasons why you should stop procrastinating and register right away!

1. 4½ days of great technical content for Oracle developers. Plenty of presentations and hands-on training on several areas such as APEX, BI, development tools, SQL, PL/SQL, (more...)

@flashdba:

If any of this is ticking boxes for you, it’s time to consider what flash could do for the performance of your database:

• I/O wait times are high. Essentially we are looking for high latency from the existing storage system. Flash memory systems should deliver I/O with sub-millisecond (more...)

I find APEX tab sets cause all sorts of issues in applications, either through management or behaviour. A common request is to create some pull-down menus as a replacement.
There are plenty of options for this, including a number of jQuery plugins, but here is an example that uses only (more...)