view counter
Home

PL/SQL Feed

Oracle PL/SQL (Procedural Language/Structured Query Language) resources, news, and support articles.

Exadata Hybrid Columnar Compression

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 »

May 04, 2013 12:33pm

Traffic Management

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!

select posts from sqlfail

May 03, 2013 1:00am

SQL*Plus tips #5: sql_text/sql_fulltext formatting(sql beatifier)

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.

Apr 29, 2013 12:53pm

Sequence out of fetch? More problems with committing in loops

create sequence ora
start with -1002 minvalue -1002;

begin
for commits in (
select loops
from queries
where we = 'specify'
for update
) loop
dbms_output.put_line(
'Causes an ' || sqlerrm(ora.nextval));
commit;
end loop;
end;
/

Apr 29, 2013 1:00am

ActivePerl on Windows

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).

Apr 26, 2013 9:48am

You don’t need to wait to be given this permission

grant read on
directory concepts_guide
to everyone;
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!

Apr 26, 2013 1:00am

MySQL Triggers with Logging

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.

Apr 25, 2013 10:01pm

MySQL 5.6 Install Steps

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.

Installation Steps

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:

Apr 25, 2013 1:00pm

Results of the Q1 2013 PL/SQL Championship

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.

Apr 24, 2013 10:47am

A Private Place to Manage Working Data

create global temporary table
contains_data_that_is (
only_visible_to_one_session
varchar2(1) default 'Y',
and_by
varchar2(50) default 'removed on commit',
unless_you_state
integer
) on commit preserve rows;

I've always found the "global" naming of temporary tables slightly confusing,
as

Apr 22, 2013 1:00am
view counter