Oracle Database 12c: In Line PL/SQL Functions in SQL queries
At long last it’s here: Oracle Database 12cR1. The download of this fresh software package is hardly done. It is time to start sharing some of our early experiences …
Category: PL/SQL
JDeveloper code templates
When you write a lot of code, no matter what sophisticated framework you use, there are pieces of code that you end up writing over and over again (especially …
Hotsos 2013 – Presentation material “Creating Structure in Unstructured Data”
Hereby, for those who want another look or for people to share, my presentation content “Creating Structure in Unstructured Data” given during the Hotsos 2013 Symposium on Monday morning. …
Oracle SQL: Using subquery factoring in an INSERT statement
I use subquery factoring a lot, to make my SQL queries easier to write. This basically means that most of my queries these days start with WITH rather than …
Using TRUNC in SQL to get the first date in a period
While working on a Web application that required some page to report data aggregated on several levels of time period – by month, quarter or year – I ran …
Hotsos Revisited 2013
January 28, 2013
AMIS, Architecture, Big Data, Database, DBA Oracle, Oracle, PL/SQL, XML
No Comments
Van 3 tot en met 7 maart vindt in Irving, Texas, het internationale Oracle performance Hotsos Symposium plaats. Dit jaar belooft het symposium een garantstelling voor inhoudelijk hoogstaande presentaties …
OTN Yathra 2013 – The six city Oracle tour of India
The Oracle ACE directors and Java champions are organizing an evangelist event called ‘OTNYathra 2013’ between 15th & 27th February 2013. The event is sponsored by the Oracle Technology …
Basisregistraties Adressen en Gebouwen – Het importeren van Kadaster BAG data in een Oracle Database
Vorig jaar heb ik behoorlijk wat vragen gekregen over of er een tool was, een methodiek, om BAG data van het Nederlandse Kadaster in een Oracle database te krijgen …
Read an Excel xlsx with PL/SQL
At the OTN SQL and PLSQL forum I promised to publish some code I use for a project I’ still working on. This code allows you to select the …
How-to backup Oracle RAC 11gR2 Database with RMAN
![How-to backup Oracle RAC 11gR2 Database with RMAN]({"aperture":"0","credit":"","camera":"","caption":"","created_timestamp":"0","copyright":"http:\/\/seattletimes.nwsource.com\/ABPub\/2012\/08\/02\/2018836700.jpg","focal_length":"0","iso":"0","shutter_speed":"0","title":"","orientation":"0"} "How-to backup Oracle RAC 11gR2 Database with RMAN")
RAC and single instance RMAN backup is similar, but… Backup of a 11gR2 RAC database is similar to that of a single instance 11gR2 database. There is an important …
ADF DVT: Visualizing valid periods using Project and Scheduling Gantt Charts
December 29, 2012
Oracle Application Development Framework, Oracle WebLogic Server, PL/SQL
No Comments
In a recent article – Advanced SQL to find valid periods – juggling with outer joins, running totals and analytical functions – I discussed how to use Analytical Functions …
Advanced SQL to find valid periods – juggling with outer joins, running totals and analytical functions
After teaching the Advanced SQL Masterclass recently, one of the attendees confronted me with an interesting challenge for me to solve with all the tools I had been discussing …
AMIS vat Oracle OpenWorld samen in speciale whitepaper
Als sluitstuk van de jaarlijkse Oracle OpenWorld conferentie brengt AMIS een whitepaper uit. Een handzaam document waarin het volledige verhaal van Oracle OpenWorld 2012 is gebundeld. Een team van …
Book review: Oracle APEX Best Practices
Oracle APEX Best Practices explains how to build robust and secure APEX applications. The authors have a proven track record in the Oracle APEX world. The intended audience of …
The Very Very Latest in Database Development – slides from the Expertezed presentation
I have just completed my first ever presentation on the Expertezed.com network – http://www.expertezed.com/ , a reprise from my session on Oracle OpenWorld 2012. This presentation includes a number …
AMIS Masterclass Advanced SQL – scherp je SQL skills in een pittige en praktijkgerichte dag – maandag 10 december
November 21, 2012
APEX, Database, Databases, Java, Oracle, Oracle Application Development Framework, PL/SQL
No Comments
Of je nu ‘klassieke’ Oracle applicaties ontwikkelt, met APEX bezig bent, een SOA landschap inricht of een Java/JEE (bijvoorbeeld ADF) applicatie bouwt: het fundament van veel van wat je …
OOW 2012: The yearly AMIS Review from Oracle Open World and JavaOne – slides available
Yesterday (16th October), 10 days of the end of the yearly Oracle show in San Francisco, AMIS organized its ‘Review from Oracle Open World 2012’ session with an overview …
OOW 2012: Little things make me happy
Yesterday evening we had the annual “We went to OOW and this is what’s new in the world we call Oracle” at AMIS. Starting around 5pm and ending around …
Kom kennismaken met AMIS en doe mee met uitdagende projecten
Hierbij nodigen we je uit om met ons kennis te komen maken. Ben jij een (junior) Oracle consultant die een stap verder wil maken? Wil je verder groeien en …
OOW 2012: The Very Very Latest in Database Development (CON4792)
Database development in the Oracle Database is crucial for creating well balanced multi tier applications. This presentation describes a number of useful facilities and application architecture considerations around the …
Re-ordering without procedural code or using a sequence
Question from one of my customers: “Please help me find an update statement that’s able to re-order a primary key after a delete.. and by the way.. you are …
OOW 2012: Is PL/SQL still alive?
Yesterday Bryn Llewellyn, Distinguished Product Manager, did a session called “PL/SQL Enhancements brought by the latest generation of database technology”. The room was packed. For the upcoming release of …
How to build an IM (XMPP) solution with Oracle APEX and Websockets
October 1, 2012
Architecture, Database, Development Tools, Oracle, PL/SQL, Web/Java, WebCenter
No Comments
Using Kaazing Websocket Gateway and OpenFire Scenario: If you, for example, have a webshop and a webshop online support application for internal use, this solution will let the webshop customer …
OOW 2012: Questions to get answered during this conference
The show of the year is around the corner: on Sunday it will all start again, the Oracle Open World conference. Tens of thousands of developers, architects, administrators, project …
OOW 2012: My Schedule
This will be my third time attending Oracle Open World and I’m really looking forward to the event. It is very hard to make a schedule, there are so …
Uitnodiging: Kom kennismaken met AMIS
September 13, 2012
AMIS, Architecture, Business Process Management (BPM), Cloud, Data Warehousing & BI, Database, DBA Oracle, Development Tools, IT, Java, Mobile, Oracle, Oracle Application Development Framework, Oracle WebLogic Server, PL/SQL, Project Management, Software Development, Software Engineering, Web HTML5 CSS3, Web/Java
No Comments
Hierbij nodigen we je uit om met ons kennis te komen maken. Ben jij een (junior) Oracle consultant die een stap verder wil maken? Wil je verder groeien en …
Forms community event during Oracle Open World: Tuesday, October 2nd – 11.30 AM
Oracle Open World is around the corner – with all the latest about Oracle products. In het hubbub of the latest and greatest, flashiest and news-worthiest, you may not …
Dinsdag 18 september: Oracle Open World & JavaOne 2012 Preview mini-conferenties – 12 presentaties op 1 avond
Van 30 september tot 5 oktober is San Francisco weer het domein van tegen de 45.000 deelnemers aan de Oracle Open World en JavaOne conferenties. Ruim 2000 presentaties worden …
Reduce occurrence of ORA-04068 while upgrading PL/SQL packages by moving global variables to Application Context
This article will argue against the use of (stateful) global PL/SQL variables – as they are both a potential problem for stateless web applications and the availability experienced by …
Compare tables with the minus operator, even if they contain clobs and/or blobs.
I wanted to compare the content of two tables with identical layout quickly with the minus set operator, but ran into a couple of errors, caused by clob and …
The Future of Forms – presentations and other resources from the May 15th event at AMIS
Tuesday May 15th, Nieuwegein – The Netherlands: During an intense day and evening, close to 120 Forms developers and architects gathered for discussions, explorations and exchange of experience around …
The Future of Forms – 15th of May – Nieuwegein, The Netherlands
April 27, 2012
Oracle, Oracle Application Development Framework, Oracle WebLogic Server, PL/SQL, SOA
No Comments
Sporting a selection of the world’s best known speakers in the area of Oracle Forms and Forms modernization – on Tuesday 15th May AMIS will host an all day …
Generating a PDF-document with some plsql: as_pdf_mini => as_pdf3
It has been more than a year since I published my previous blog on generating PDF with pl/sql. In that time I’ve rewritten as_pdf two times, so now its …
AMIS proud sponsor of the SQL Challenge
SQL today is the foundation for any successful application. Whether it is a SOA implementation, an ADF or APEX application, a Forms application or any other usage of the …
Advert: Dutch preview event ‘Collaborate 12’
March 31, 2012
AMIS, Announce / Events, Database, IT, Oracle, Oracle E-Business Suite, PL/SQL
1 Comment
‘COLLABORATE 12: Technology and Applications Forum for the Oracle Community’ is de grootste Oracle gebruikersgroep conferentie ter wereld en wordt jaarlijks georganiseerd in de Verenigde Staten. Het is hét …
Java is niet eng! introductie van Java voor PL/SQL ontwikkelaars – donderdag 5 april
Veel PL/SQL ontwikkelaars hebben (n)iets met Java. Aan de ene kant zien ze dat Java op veel plekken wordt gebruikt, binnen en buiten de Oracle technology stack. En dat …
Oracle XML Training With Marco Gralike
I was asked by Jože Senegačnik, if I would be would be interested in doing a Masterclass/Seminar in Slovenia and, yes of course, I really liked the idea. So …
Masterclass Oracle 11g voor Database Ontwikkelaars – haal meer uit SQL en PL/SQL in 11g
Aanstaande vrijdag 27 januari verzorgt Oracle ACE Director Alex Nuijten bij AMIS Services in Nieuwegein een Masterclass voor Oracle Database Developers: iedereen die met enige regelmaat SQL en/of PL/SQL …
Using the Oracle XMLDB Repository to Automatically Shred Windows Office Documents (Part 1)
December 20, 2011
AMIS, Architecture, Big Data, Database, DBA Oracle, Oracle, PL/SQL, XML
7 Comments
People who have attended the UKOUG presentation this year where Mark Drake, Sr. Product Manager XML Technologies / XMLDB, Oracle HQ, and I demonstrated the first principles of the …
Factorial in Oracle SQL – using both new Recursive Subquery and classic Connect By approach
I regularly teach a masterclass on Oracle SQL. One of the topics I explore in depth is the use of the CONNECT BY query style to perform not just …