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 a row than a row based … Continue reading »
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!
select posts from sqlfail
Sometimes I get tired of watching unformatted query text from v$sqlarea, dba_hist_sqltext in SQL*Plus, so I decided to include automatic query formatting in my scripts.
I thought that there are many libraries for such purposes on languages which i know, and it’s true, but it turned out that many of them are not appropriate for Oracle.
So I took the most appropriate – perl module SQL::Beautify and corrected it. Now i can share my first solution.
create sequence ora
start with -1002 minvalue -1002;
for commits in (
where we = 'specify'
'Causes an ' || sqlerrm(ora.nextval));
I actively maintain virtual test instances for my writing and teaching on Windows 7, Red Hat Enterprise Linux, Fedora, and Solaris. Perl on Windows is always interesting. I use ActivePerl on Windows 7 rather than Strawberry Perl, and it was interesting to see this note after I upgraded to the most current Community Edition of ActivePerl (5.16.3).
grant read on
It's always slightly disappointing seeing how many forum questions could be answered by a quick and easy look at the relevant section of the concepts guide and/or general manuals
But now you’ve got it, head here to read it!
Somebody asked why you can’t implement MySQL triggers that write information when you want to stop the DML statement, like autonomous procedures in Oracle. The question was a surprise but I didn’t find anything on it, so here’s how you can do it. This is more or less like an autonomous process by leveraging both the InnoDB and MyISAM engine’s behaviors. This post leverages an earlier explanation of MySQL Triggers.
My install instructions on the web site were old, somebody wanted me to publish another set of screen capture for the MySQL 5.6 install and configuration. This is it for Windows 7 using the downloadable MSI file.
The installation from MySQL’s perspective is actually the installation and configuration of MySQL. For your convenience and reference, I’ve already installed the pre-requisites for MySQL. They’re:
You will find below the results for the Q1 2013 PL/SQL championship; the number next to the player's name is the number of times that player has participated in a championship.
Congratulations first and foremost to our top-ranked players:
1st Place: kowido of Germany wins: Amazon.com US$250 Gift Card .
2nd Place: Frank Schrader of Germany wins: Amazon.com US$175 Gift Card.
3rd Place: Vincent Malgrat of the French Republic wins: Amazon.com US$100 Gift Card.
create global temporary table
varchar2(1) default 'Y',
varchar2(50) default 'removed on commit',
) on commit preserve rows;
I've always found the "global" naming of temporary tables slightly confusing,