Posts tagged plsql
Yesterday evening we had our annual Oracle Open World review at our office in Nieuwegein. Around eighty people attended and all were very involved with the session. Five AMIS employees were at Oracle Open World, and each one covered one area of interest.
Before dinner Lucas gave an overview of the trends and topics that were covered at Oracle Open World. Just to convey the sheer size of OOW, Peter illustrated this by facts (number of people attending, number of lunches served, etc) as well as by photos. I’m still very impressed that they covered a four lane street (Howard street) by a tent, just to serve lunch… amazing. Marco and myself gave an overview of what AMIS was doing at OOW, as well as the Oracle ACE Directors briefing right before OOW started.
There were a number of goodies that we took from Oracle Open World to give away this evening. We decided to do it a little different this year, we organized a BuzzWord Bingo. Each of the attendees was given a bingo sheet with some of the buzzwords that would be covered during our presentations. Before we went for dinner six people had bingo and got their goodies to take home.
This time we had a Mexican Style dinner, very lovely. More >
Xenogenetics for PL/SQL: Infusing with Java Best Practices and Design Patterns (presentation at OOW 2010)0
Xenogenetics for PL/SQL: Infusing with Java Best Practices and Design Patterns – Alex Nuijten and Lucas JellemaPL/SQL is a venerable programming language that is both vital and very much alive. This session will discuss how we further rejuvenate and enhance the way we create PL/SQL programs. We’ll tap into the world of .NET, Java, and other modern programming language to do some cherry picking: what are the very best practices, concepts, and design patterns and how can we apply them to PL/SQL? We’ll explain and demonstrate dependency injection, the observer pattern based on listeners, aspect-oriented programming (AOP), the decorator and template pattern, use of user-defined nested types, and collections.
PL/SQL is a venerable programming language that is both vital and very much alive. This session will discuss how we further rejuvenate and enhance the way we create PL/SQL programs. We’ll tap into the world of .NET, Java, and other modern programming language to do some cherry picking: what are the very best practices, concepts, and design patterns and how can we apply them to PL/SQL? We’ll explain and demonstrate dependency injection, the observer pattern based on listeners, More >
Oracle Open World 2010 presentation: Forms2Future: the ongoing journey into the future for Oracle based organizations0
Many organizations around the world have adopted Oracle technology for developing custom applications. Over the past two decades, they may have used PL/SQL, Reports, Forms, Designer, Portal or the Web PL/SQL Toolkit. Many of these organizations have come to face new challenges: more agility or functionality, new user groups or channels or more efficient maintenance. Or they fear getting stuck in the past, running out of support or qualified and motivated resources. What is the right way to approach the future? What mix of tools, how and when to adopt which new technology, how to build a business case? This session recounts various more and less successful warstories of organizations that embarked on a journey into the future.
Peter and I today did our session together about the road to the future for organization that heavily us Oracle software. It was a good session with a lot of interesting questions. It is quite clear to me how much confusion there is, how many organizations are struggling with defining their future plans. How many people hear mixed messages from for example Oracle sales people. And how they simply would like to get a clear, untainted and unbiased picture of More >
Back in 2004 when we started with the AMIS Technology Blog, my main objective was to record the things I infrequently do in order to have notes describing the steps to go through whenever I needed to do the thing again. I was own primary audience, so to say. Over the years, the articles have increased in complexity and sometimes in absurdity too. This one is back to that original intention. This article is not fancy at all – even though it touches upon a powerful (and underrated) subject: the Advanced Queue in the Oracle RDBMS. For the 1000s of database developers and architects that make frequent use of AQ, I am not going to add anything: this article merely shows the steps for creating an Advanced Queue, how to register a listener on the queue and how to publish a message on the queue. That is not fancy at all, obviously.
What is extremely fancy and powerful – and not nearly used enough – is the architectural pattern that AQ allows us to introduce. Queues are a key concept for achieving decoupling. Decoupling itself is like the holy grail of architects – because it allows agility and reuse. Through a Queue, a publisher (or discoverer) of events can make them available to More >
Some days ago a collegue of mine asked if I could made something for him to unzip a Microsoft Word 2007 docx file. And of course in the database and without using Java. (more…)
Oracle has a a supplied package utl_compress, which can be used to compress and decompress data with PL/SQL. According to the documentation it uses the “Lempel-Ziv compression algorithme”, and “The output of the UTL_COMPRESS compressed data is compatible with gzip”. That means it’s following the RFC 1952 specs, RFC 1952. And that may be very useful (but I have never used it), but I need compression (I’m working on a PDF-generator in PL/SQL) and decompression (unwrapping wrapped PL/SQL!) in the zlib-format, RFC 1950. Both formats use the same algorithm, RFC 1951, but have different headers and trailers. So can utl_compress be used to for compressing/decompressing data according to the zlib-specs. Yes! (more…)