Alex Nuijten
(0 comments, 75 posts)
This user hasn't shared any profile information
Posts by Alex Nuijten
Oracle Open World 2011: Oracle Database 11g Features for Developers by Connor McDonald
0Yesterday I had the pleasure of attending a session by Connor McDonald. I heard a lot about him, his presentation style, and I even did a book review back in 2005. Everybody I talk to who attended a session by Connor – ever – is always very positive on his presentation style. And it is very impressive, humor, technical knowledge, all the ingredients are there to keep you focused on the content. The opening slide, he put on as you walked in the room invited you to move forward as the presentation has code sample in a fontsize which he showed on the slide. The room filled up, and it was a large room. There was another benefit of being in the front of the room, apart from being able to read the slides, he handed out chocolates – starting from the front. Talking to Connor later in the evening, he told me it takes months to prepare for a presentation, and it really shows. If you get a chance to see Connor do a presentation, attend it and make sure to arrive early! Part of the presentation was on Edition Based Redefinition, and because I presented on that subject before I believed there was a flaw in his presentation. But there was not, I was mistaken. The rest of this blogpost shows More >
Oracle Open World 2011; Unstructured Data and Multimedia SIG
0Oracle Open World is underway. My first session, which I didn’t plan, was on Unstructured Data. There is a lot of unstructured data going around, as opposed to relational data, and it will only increase in the future. The number of images and videos will only increase in the future. Especially for this, Marcelle Kratochvil is putting together an Oracle Unstructured Data with Multimedia SIG, just to spread the word on unstructured data and multimedia. She even put up a website (to be moved in the future) with white papers, preseentations, and links to other useful information. This site can be found at https://sites.google.com/site/ommuds/home. Head over there and check it out. She also showed some very nice examples of customers using multimedia. Unfortunately I had to leave at this time. Even though I didn’t plan on attending this session, it was very interesting – too bad I had to leave for a different session, but I will surely be investigating more on unstructured data.
Where am I, and what am I doing… Oracle Open World 2011
0This post is more for me than it is for you, at least I will have a place to quickly check where am I supposed to be going next.The rest of this post is basically just my schedule for the upcoming week in San Francisco. Really looking forward to all the sessions, meeting old friends and making new ones. So if you see me walking around, please come up and say hello.
Oracle Open World / Java One Preview bij AMIS
0Op maandag 19 september zal er bij AMIS een Oracle Open World Preview sessie worden gehouden. Een groot deel van de Nederlanders die het dit jaar gelukt is om aanwezig te zijn als spreker op Oracle Open World zullen hun presentaties geven in Nieuwegein. AMIS-ers Lucas Jellema, Alex Nuijten, Peter Ebell en Aino Andriessen zullen in drie parallel sessies presentaties verzorgen. Daarnaast zullen andere Nederlandse presentatoren – zie hieronder de lijst met sprekers – presentaties verzorgen.
Heb je dit jaar niet de kans om in San Fransisco aanwezig te zijn, meld je dan aan voor deze preview sessie Oracle Open World 2011!
Zaal 1 Zaal 2 Zaal 3 17:00 – 18:00 Lucas Jellema Aino Andriessen Alex Nuijten 18:00 – 19:00 Diner Diner Diner 19:00 – 20:00 Jacco Landlust Kees Jan Koster Peter Ebell 20:00 – 21:00 Lonneke Dikmans Kees Jan Koster/ Jeroen Borgers Lucas Jellema – Instant Agility in Oracle Fusion Middleware Through Design Time @ RuntimeThis session will discuss quality aspects of an ADF Fusion application. It will demonstrate how to address, manage and measure quality and will show what tools can be used to leverage the development process to create high quality ADF More >
Business Rule: Only One per Day, but keep the time
5The business rule states:
Only one entry is allowed per ID and per day and the time should be recorded.
The table involved (simplified for the blog post)
SQL> create table test 2 (id number 3 ,inspection_dt date 4 );Wouldn’t it be nice if it was possible to do it like this?
SQL> create table test 2 (id number 3 ,inspection_dt date 4 ,constraint one_per_day unique (id, trunc (inspection_dt)) 5 ); ,constraint one_per_day unique (id, trunc (inspection_dt)) * ERROR at line 4: ORA-00904: : invalid identifierThis way you still have the complete date information (time is a component of the date column), and only use the TRUNC (inspection_dt) to constrain the data entry. As you can tell from the error message, this is not allowed. Oracle 11g Release 1 introduced Virtual Columns which can implement this requirement declaratively.
Recent Comments