JSON parser for PL/SQL in Apex 5 ?
Even though the package is not installed (more...)
Read and monitor Oracle related blogs and news sources, all in one place.
insert into joyous_memories
select making_vast_improvements
from that_horrible_query
union all
select designing_data_models
from scalable_applications
union all
select heart_warming_smile
from your_newborn_child;
While there can be a lot of effort put in before getting these outcomes, the reward is worth it! :)
Introduction
In my work among other things I tune and tweak solutions for EXADATA. Today I’ll write about a big improvement we achieved with a process that moves data from the operational tables to the ones where the history is stored.
This will not be a technical post. While I (more...)
Carlos Sierra:
Since lack of Histograms or freezing CBO Statistics do not guarantee Plan Stability, do not rely on these two myths. If what you are looking for is Plan Stability use then SQL Plan Management available since 11g or SQL Profiles available from 10g.
create table fractional_digits_disappear (
without_warning_when_put_in_an integer
);
insert into fractional_digits_disappear (
without_warning_when_put_in_an
) values (
3.141592
);
select *
from fractional_digits_disappear;
WITHOUT_WARNING_WHEN_PUT_IN_AN
------------------------------
3
The fractional seconds of timestamps are also silently (more...)
I’ve kept pretty busy since coming back from Collaborate 2013 last month, working on new solutions for my company OraPlayer and getting ready for Kscope 2013.
One of these new solutions is a LIVE DEMO of our Oracle Forms to ADF Mobile solution. We have developed a small Android app (more...)
Oracle’s advanced partitioning has some deficiencies. For example, partition info is missing in V$SESSION_LONGOPS for scan-operations ( full table scans, full index scans ). V$SESSION_LONGOPS.TARGET only shows OWNER.TABLE_NAME in these cases, even when the underlying table/index is partitioned, though the longop doesn’t refer to the whole segment but (more...)
select count(*)
from babies
where crying = any (
select understanding
from parents
);
COUNT(*)
--------
0
If anyone ever manages to create a baby-to-parent translation device,
I'm sure they'll become the richest person in the world!
When I upgraded from Xubuntu 12.10 to 13.04 today, all my existing Python virtualenvs broke! Fortunately, they're just virtualenvs and easy to replace (that's kind of the point). But don't panic if you start seeing these.
$ ipython
Traceback (most recent call last):
File "/home/catherine/ve/e2/bin/ipython", line 5, in
(more...)