Back in mid-March, I wrote:
A week ago, I played a game of Scabble with Veva and scored 32 points by placing the word "SEEN" on the board. Now, every letter in "SEEN" is worth 1 point, making it very difficult to get to 32 points. But I attached "SEEN" to a word on the board (of course!) and I got my 32 points by using a total of 8 letters, two of which were worth 3 points and the other 6 were worth 1 point each.
Haven't shaved for two weeks. Decided to give my skin a break, and I also wondered: what do I really look like? Shaving my head is, I have come to accept, the "main vain" thing I do in my life (well, that and painting flamboyan flowers on my toenails).
How much gray and white is there? Answer: Lots.
How much is left on top? Answer: Not very much.
Back in April 2010, I started up the PL/SQL Challenge (www.plsqlchallenge.com) to provide quizzes on PL/SQL, SQL, logic and Oracle Application Express.
Hundreds of people take these quizzes each day. Since that time, over 670,000 answers have been submitted by thousands of Oracle technologists.
But you can't please everyone. I received this outraged message yesterday regarding the PL/SQL Challenge.:
drop procedure is_not_really_gone_but;
select object_name || ' ' || object_type
as "Continues on"
where object_name =
create table is_not_really_gone_but (
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!