Friday, November 26, 2010
Perl and Oracle
This page (http://www.orafaq.com/wiki/Perl) shows all the basics of setting up a perl script connection to an Oracle database can making basic calls...
PHP Oracle FAQ - Oracle Wiki
PHP Oracle FAQ - Oracle Wiki
A very good page showing how to work with PHP and Oracle.
I stumbled onto this page as I was just looking for a sample/simple stored procedure to borrow:
create procedure proc1(p1 IN number, p2 OUT number) as
begin
p2 := p1 + 10;
end;
|MG| Win7codecs 2.6.9 Download
|MG| Win7codecs 2.6.9 Download
There is something mysterious about codecs ... this one comes highly recommended :)
ORACLE-BASE - Recompiling Invalid Schema Objects
ORACLE-BASE - Recompiling Invalid Schema Objects
this is a good background summary page... the commands I like to keep at my fingertips are:
spool pre-compile-errors.lst
col owner form a15
col object_name a60
set line 100
select OWNER, object_name, object_type, status from dba_objects where status <> 'VALID';
spool utlrp.lst
@?/rdbms/admin/utlrp
spool post-compile-errors.lst
col owner form a15
col object_name form a30
set line 100
select OWNER, object_name, object_type, status from dba_objects where status <> 'VALID';
expdp/impdp, remap_schema and Oracle Wiki
Data Pump Export (expdp) and Data Pump Import(impdp) - Oracle Wiki
The Oracle wiki is great - a clear and concise repository of examples of standard DBA commands... I have been using remap_schema with impdp today. This wasn't on the page but all the basics of expdp and impdp were.
Saturday, June 12, 2010
Amsterdam foam - Ari Marcopoulo
Amsterdam is quite incredible, although it feels quite compact and friendly, you can easily walk across the city following beautiful canal paths and charming little streets.
However Amsterdam has a huge collection of museums, galleries, theatres and lots of charming buildings.
Foam is housed in a beautiful old canal mansion on Keizergracht, but unlike the "van Loon", on the opposite side of the canal, the inside of Foam is total modern with steel tubing and cobolt blue glass. The content of the gallery is very modern too, starting with Ari Marcopoulos who's work captures his interesting and colourful way of life, friends and family, plus the odd celebrity (e.g. Robert Mapplethorpe looking rather elegant):
Ari Marcopoulos (b. 1957) is an Amsterdam-born photographer and filmmaker, living and working in New York and California[1]. As a photographer, film artist and adventurist, Marcopoulos, who began his career in New York City assisting Andy Warhol, transplants himself into the intimate lives of people living on the edge. Artists, snowboarders, musicians and skateboarders have been both muses and commercial subject-matter throughout his quarter century career as a photographer.
Saturday, April 10, 2010
Carl Rosa Opera: The Pirates of Penzance
Saw a fantastic production of The Pirates of Penzance.
I like Musical and Gilbert and Sullivan is great fun - I know this has been out of fashion for some time but maybe it's on its way back!?
This production was fantastic, the costumes, the make-up, great comic timing, the orchestra and most of all the singing!
I think I first saw Gilbert and Sullivan aged 15, as an amateur production done at the local all girls private school (my mother taught physics their). I remember being really impressed - I think they teamed up with local boys private school. This was elite schooling at it best, teenagers doing something quite remarkable.
Today's production was cracking again - I was really impressed with the Carl Rosa Opera company! Mabel (lead soprano) trilled beautifully, a soaring wonderful voice. Samuel was sung by a well-rounded and deeply comfortable voice.
This is sung nearly perfectly by a very talented ensemble, complemented by some excellent individual performers, including two members of the original cast of Phantom of the Opera. Everyone sang well with brilliantly clear diction too, something so very necessary in getting across the full humour and cleverness of the lyrics. Rosie Ashe as pirate wench Ruth was superb, dexterously handling her exposition-heavy lyrics yet still hitting all the right comedic notes; Barry Clark’s Major General and Bruce Graham’s Police Sergeant were both nicely bumptious and Katy Batho impressed with a piercingly clear voice, hitting those top notes with a beautiful sound.
Subscribe to:
Posts (Atom)