I’m a taxonomy practitioner at Fishbowl Solutions who has worked with many companies to implement simple to sophisticated document management systems. I’ve noticed over the years the large number of obstacles that have prevented companies from establishing taxonomy frameworks to support effective document management. I won’t review an exhaustive alphabetic list of obstacles, in fact, there are probably far more than 26, but I’ll highlight the top culprits that have turned even the best, most (more...)
We are happy to announce that the first mobil applications built with Formspider are now in production. You can download them from the Apple App Store using this link,
or from the Google Play Store using this link
Formspider enables PL/SQL developers to build cross platform mobile apps using only PL/SQL as the programming language.Read the story of our Dutch client
to learn more about Formspider Mobile and the possibilities it opens for (more...)
Prior to Oracle Database 12c, global temporary tables (GTTs) shared statistics between sessions, so
each GTT had one set of statistics visible to all sessions using it. Of course, gathering statistics on GTTs can be very useful because it will help the optimizer find better execution plans, but this advantage was... [Read More
Many hands make light (emitting diodes) work. Oracle Applications User Experience (OAUX) gets down to designing fashion technology (#fashtech) solutions in a fun maker event with a serious research and learning intent. OAUX Senior Director and resident part-time fashion blogger, Ultan “Gucci Translated” O’Broin (@ultan), reports from the Redwood City runway.
Fashion and Technology: What’s New?
Wearable technology is not new. Elizabeth I of England was a regal early (more...)
I have been teaching security classes about Oracle Security for many years and they are very popular and I teach many classes per year around the world; mostly in the UK and EEC but I also venture to the Middle....[Read More]
Posted by Pete On 24/05/16 At 12:43 PM
order to support a more agile project environment, OPITZ CONSULTING
developed a Java/JUnit based SOA Unit Testing Framework. Among others,
the framework was capable of using the Oracle libraries to run XQuery
tests locally and verify their correctness. Over the course of time,
Oracle released 12c and with it, changed its xquery files. A new
extension (.xqy instead of .xq) was introduced and with it additional
syntax. Oracle added a
(:: OracleAnnotationVersion "1. (more...)
Since Oracle Enterprise Manager 12C it is possible to allocate the costs of IT resources to the people of organizations who consume them. This is done through the use of the plugin ‘Consolidation Planning and Chargeback’ .
Pete Sharman wrote an excellent blog about configuring this plugin in Enterprise Manager 12c, and it’s not my intention to copy his work, so I’d like to focus on complementary stuff regarding Oracle Enterprise Manager 13c.
In this article (more...)
I recently (last week) participated in JavaCro, a great Java conference in Croatia. I have participated in that event since its inception in 2012. Here are the titles of the keynotes I presented at JavaCro over the years:
- "Unlocking the Java EE 6 Platfom" (29 - 30 May, 2012, in Tuhalj)
- "Unlocking the Java EE platform with HTML5" (3 - 5 June, 2013, in Tuhalj)
- "Consuming Java EE Backends in Desktop, Web, and Mobile (more...)
This is really messed up. I chose GoldenGate because I did not want to mess around with streams.
When using Integrated Capture or Delivery, then knowing streams is a prerequisites.
Apologies as the format is not pretty.
The QUEUE table was indeed missing and this is what I get for monkeying around.
To resolve the issue – exec DBMS_STREAMS_ADM.REMOVE_STREAMS_CONFIGURATION();
GGSCI (arrow.localdomain as ggs_admin@hawk) 3> unREGISTER EXTRACT e_hawk DATABASE
2016-05-23 19:16:32 ERROR OGG-08221 Cannot (more...)
This posting is to try to clarify what is supported when using Enterprise Manager Cloud Control 13c (EM13c) and Amazon Web Services (AWS). The question came from some of our sales consultants who were finding confusing information about what is actually supported when using EM13c and AWS, so I have asked our Support folks to write a support note to provide the definitive answer on this. While that is being written, I thought I would (more...)
BDB User Authentication
(courtesy of Brayden Zhang)
In Berkeley DB 6.2, user authentication extension is added into the SQL interface. The new user authentication layer is both secure and easy to use. In this article, we will introduce how to use the user authentication, and also... [Read More
Here's what I'm working on in the context of Jigsaw, which kind of proves the awesomeness of the NetBeans APIs, since this is provided by an external NetBeans module. Take a look at the icons on the packages in the Projects window. Two of them have an unlocked lock icon ("com.wordlibrary" and "com.wordlibrary.spi") while the other two have a locked lock icon. The unlocked lock icons indicate that those packages have been (more...)
In a couple of weeks, I will be presenting the following sessions at the HIUG Interact 2016 conference in San Antonio
- 16165 : PeopleSoft Fluid User Interface – Deep Dive: Grand Oaks D, Mon, Jun 13, 2016 (03:15 PM - 04:15 PM)
- 16164 : PeopleTools Tips & Techniques: Grand Oaks D, Tue, Jun 14, 2016 (02:30 PM - 03:30 PM)
- 16163 : Tech Clinic: Application Designer Grand Oaks D, Wed, Jun 15, 2016 (12:30 PM (more...)
Today’s post is courtesy of this question from a reader:
Can the SQLDeveloper Report/Chart feature create a line chart where x contains date/time and y the values to be plotted?
The answer is ‘Yes!’
I’m going to use HR.EMPLOYEES to give me my data.
I start with…
SELECT Hire_date,... [Read More
Here’s a story of (my) failure prompted by a recent OTN posting.
The OP wants to use composite partitioning based on two different date columns – the table should be partitioned by range on the first date and subpartitioned by month on the second date. Here’s the (slightly modified) table creation script he supplied:
CREATE TABLE M_DTX
VC GENERATED ALWAYS AS (EXTRACT(MONTH FROM DATE2))
Those of you who know me will know that I’m working at Cedar and we’re moving from PeopleSoft to the Oracle Cloud. I won’t talk about the company’s journey, but more how I’ve found the transition personally.
In brief, there’s a lot to learn.
Data Model knowledge
In the PeopleSoft world, once you know the table structures you could work significantly faster. Whether you were writing an SQR, an App Engine, an XMLP report, a (more...)