JDBC connection samples in Oracle Enterprise Data Quality (OEDQ) to Oracle Service Name and MS SQL SSL
This post is just a quick note to myself on how to configure JBDC on Oracle Enterprise Data Quality (OEDQ) to connect to different databases.
First let’s talk about connecting to Oracle database. By default, OEDQ’s Data Store can only connect Oracle database by SID, but not by Service Name.
Fortunately, the JDBC connection option is available to take advantage of the connection string that can support Service Name and multiple hosts if needed.
Let's start with the Object Navigator. Left side is Forms 11g, right is Forms 12c.
There are absolutely no changes between the two versions.
Same picture when we look at the menu and toolbar. No changes.
And now we see the big difference between 11g and 12c. The last decades Forms was known as (more...)
Below is a SQL statement from a performance problem I was looking at the other day.
This is a real-world bit of SQL which has slightly simplified and sanitised but, I hope, without losing the real-worldliness of it and the points driving this article.
You don’t really need to be familiar with the data or table structures (I wasn’t) as this is a commentary on SQL structure and why sometimes a rewrite is the best (more...)
In this series of posts and videos, we will explore creating and deploying a SOA composite using Oracle Developer Cloud Service.
Since then I've signed up, had a play, interacted with people and with the support of apex.world I thought about what it could do for our community. Slack's mission is “make your working life simpler, more pleasant and more productive.” To me that sounds like something we should think about (more...)
The best news on Friday Oct 23rd was that version 4.1.2 of Data Modeler came out! We were really waiting for this release because of some bugs on 4.1.1 that made our lives quite difficult. Thank you development team for fixing everything so quickly and releasing 4.1.2 so fast! If you…
With Apex 5 and the Universal Theme, tabs come built-in and setting it all up is extremely easy.
To add tabs, just add a Static Content region to the page, and change its template from "Standard" to "Tabs Container".
Then add Sub Regions to the region. In the component tree, any sub regions (more...)
You can play the game yourself at
The about section allows you to download the current source I have exported.
I originally wasn't going to submit anything since I was busy writing a book this year, but I got inspired by something one day and thought I could at least submit something as long as I follow two (more...)
- das (more...)
JDeveloper 12.2.1 now provides complete integration with Developer Cloud Service comparable to what exists in OEPE and NetBeans. If you're an Oracle Developer looking for an IDE that supports Oracle DevOps solutions, you should check this out. Task Management, Continuous Integration, Source Control Management and Deployment. All from your IDE.
- Mauro Pagano: Using SQLd360 – introduction video
- Carlos Sierra: Using eDB360 – introduction video
- Mauro Pagano: Introducing Pathfinder, is there a better plan for my SQL?
Windows 10 was a little bit to new for my first installation.
So I tried today Windows 8 in a virtual machine. And that's it.
The difference to my first installation is, that the Forms Configuration Manager didn't start.
In Windows 8 the Configuration Manager did start without problems. These steps were shown in (more...)
After months of waiting and anticipation. Oracle Forms 12c was released today at the kick off of Oracle OpenWorld. And if you don’t believe me download it HERE !
Join us at Oracle OpenWorld to see demo’s and learn more about 12c new features and Oracle Forms cloud support and mobility. Schedule your 1:1 meeting HERE.
You can set the threshold values for green and red (and everything in-between will be yellow). Also, you choose whether high values are good or bad.
Since the item itself is a regular Apex item, you can assign a value to it using a computation, process, PL/SQL expression, etc.
apex.world announced, everyone feeling the awesome.
I joined slack, I must say the curiosity rover self portrait helped sway my decision.
Got involved in some geeky discussions, bounced some ideas around.
Put my hand up to help with content.
Now involved in apex.world project.
I must say, after talking with Juergen he's affirmed my first impressions of this project. It's 100% community (more...)
So I will try to attend the Bloggers Meetup:
I have heard a lot of good about it, so I am looking forward to see for myself ;-) Viewing who has RSVP'ed at either link, I know I spot some (more...)