Tag: Database
Oracle Database can act as an HTTP server – using the Embedded PL/SQL Gateway (the 10g successor of the MOD_PLSQL gateway). With just a few statements, we can have …
In a previous article – https://technology.amis.nl/2015/03/15/docker-take-two-starting-from-windows-with-linux-vm-as-docker-host/ – I have discussed my first steps with Docker. With Windows as my host environment I used Vagrant to create a VirtualBox VM …
This article continues the story from Mobile backend with REST services and JSON payload based on SOA Suite 12c for Live Mobile Hacking with an OFM 12c red stack …
To allow the Oracle Database to produce meaningful log, audit trail and trace information that allow problem analysis of issues and interpretation and optimization of run time behavior, it …
In a previous article – https://technology.amis.nl/2015/03/03/preparation-for-live-mobile-hacking-with-an-ofm-12c-red-stack-budapest-2015/– I introduced the challenge Luc Bors and I were facing for the Live Mobile Hacking session at the Oracle Fusion Middleware EMEA Partner …
The title of this blog is unfashionably long – and really says it all. The ECID (Execution Context ID) that is used in Fusion Middleware to identify a conversation …
or A closer look on database hosts The last couple of years quite a few organizations had a difficult time and internal costs where a main focal point was …
An Oracle Enterprise Management Agent 12c that has to manage hundreds of objects needs extra tweaking. If not, it will not start, or it will die soon, leaving you …
Recently I came across the situation where I knew for a fact that my sessions to the database were dead because I pulled the power plug out of my application …
Oracle OpenWorld 2014 is over. Just under a week, full to the brim with information, events, people, energy, plans, hopes and expectations. I have learned many, many things. Small …
One of the often given advices on hardening a database is to run scripts without broadcasting your login data at the same time. According to Arup Nanda in his …
Half a year ago, my colleague Remco wrote an article on auto starting the listener and the databases after a host reboot. As usual with Oracle, there are several …
When using the Oracle SOA Suite for web service development, chances are that you are also using an Oracle database and that you are at some point in need …
In the past few hours, Douwe Pieter van den Bos released the second issue of OTech Magazine to the world. This magazine contains 17 articles from expert authors around …
Lucas Jellema
November 15, 2013
AMIS, APEX, Architecture, Business Process Management (BPM), Cloud, Data Warehousing & BI, Database, DBA Oracle, Development Tools, Java, Oracle, Oracle 12, Oracle Application Development Framework, Oracle WebLogic Server, PL/SQL, SOA, WebCenter
Oracle OpenWorld is a monster event – 10Ks of attendees, thousands of sessions and 100Ks of private conversations that all help convey and define the message about Oracle’s strategy …
In this article a second brain dump with observations from the Oracle OpenWorld and JavaOne conferences. These are fairly raw notes – primarily for my own consumption. They may …
Imagine this: You have consolidated you applications into one database (version 10gR2). You take a full backup every Tuesday and Thursday evening and an archivelog backup every few hours. …
Recent press releases as well as the comment provided by Oracle’s top brass around the FY14 Q1 earning provide some insight in what the key stories seem likely to …
Saskia van der Maat
July 31, 2013
AMIS, Cloud, Data Warehousing & BI, Database, Mobile, Oracle, Oracle Application Development Framework, Oracle WebLogic Server, PL/SQL, SOA, WebCenter, XML
Vanaf 22 september vindt in San Francisco de Oracle OpenWorld conferentie plaats: hét evenement waar Oracle haar productstrategie uit de doeken doet en waar Oracle specialisten van over de …
In a recent post (https://technology.amis.nl/2013/07/24/oracle-database-12c-find-most-valuable-player-using-match_recognize-in-sql/) I described how we can use the new Oracle Database 12c MATCH_RECOGNIZE operator to spot patterns in records and derive results from those patterns. …
One of the very nice new features in SQL in Oracle Database 12c is the MATCH_RECOGNIZE operator. MATCH_RECOGNIZE adds a facility for spotting patterns in records. This allows us …
Flashback started out as a feature in Oracle Database 9i. Although to be honest it is just the opening up of a mechanism that has been at the core …
I am first and foremost a developer. I am not an administrator. I know more about IDEs and GUIs than about command line. I have always been a little …
When a record is no longer active – it is logically discarded – you may want to delete it. However, the record may still be required – for compliancy …
Oracle 8i (8.1.6 if I remember correctly) started with the introduction of a that wonderful new phenomenon in SQL: Analytical Functions. Functions that basically allow the result for one …
Joining is a key ingredient in most SQL queries. Using collections (aka nested tables) that are produced on the fly inside the SQL query or that are returned by …
Oracle Database 12c ships with a brand new supplied package called UTL_CALL_STACK. This package provides an API for inspecting the PL/SQL Callstack. The package complements the DBMS_ UTILITY.FORMAT_CALL_STACK …
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 …
To be useful, data held and used in information systems has to live up to a number of expectations. The data should be an accurate representation of its source. …
Data Constraints are essential in protecting the integrity of the data in any relational database. The Oracle Database provides four types of declarative constraints that help implement various types …
Robbrecht van Amerongen
October 9, 2012
AMIS, Announce / Events, Architecture, Data Warehousing & BI, Databases, Development Tools, Java, Mobile, Oracle Application Development Framework, Oracle WebLogic Server, PL/SQL, SOA, Software Development, Software Engineering, Tools, Web HTML5 CSS3, Web/Java, WebCenter
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 …
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 …
Last night, Oracle Open World 2012 kicked off with the keynote session by Larry Ellison. In just under one hour, and with a novelty for Larry watchers (no more …
Betty van Dongen
September 12, 2012
AMIS, Database, Databases, Java, Oracle WebLogic Server, Software Development, Software Engineering, Web HTML5 CSS3, Web/Java, XML
On a recent project, I ran into a problem with an XML document, that had to be enclosed within another XML document, generated from a database query. The problem …
Lucas Jellema
August 31, 2012
AMIS, Business Process Management (BPM), Cloud, Data Warehousing & BI, Database, DBA Oracle, Java, Mobile, Oracle, Oracle Application Development Framework, Oracle WebLogic Server, PL/SQL, Web HTML5 CSS3
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 …
Any web application contains boilerplate text: text that is not part of the enterprise data from web services or databases that is manipulated by the end users using the …
Any web application contains boilerplate text: text that is not part of the enterprise data from web services or databases that is manipulated by the end users using the …
Any web application contains boiler plate text: text that is not part of the enterprise data from web services or databases that is manipulated by the end users using …
Any web application contains boiler plate text: text that is not part of the enterprise data from web services or databases that is manipulated by the end users using …
Availability is a highly desirable aspect of Fusion Middleware application. Planned downtime therefore sounds quite silly. However, the introduction of changes to applications has typically been associated with the …
![OOW 2012: The Very Very Latest in Database Development (CON4792)]({"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"} "OOW 2012: The Very Very Latest in Database Development (CON4792)")
