SQL Logic Overkill, again …

It’s interesting to watch people try to solve problems. For example, in a lab exercise that I wrote the simple fix is to replace an external file value with a scalar subquery in an INSERT statement. There’s even a hint about how to fix the external file value in the CSV file.

The approach here was interesting and worked. However, it’s wrong on two levels:

INSERT INTO transaction
(SELECT   transaction_s1.nextval
 ,        tr.transaction_account
 ,         (more...)

In Memoriam

My mother died a few weeks ago after a couple of months in terminal care. One of my tasks while she was in care was to go through all her paperwork and while doing so I discovered a couple of stories from her past that she had typed out (remember type-writers?) about 30 years ago. I typed them up on my laptop and printed several copies to hand out for people to read at (more...)

Free Oracle HCM Cloud backgrounds

It’s a common practice to change the background colour of your environments to give a visual clue which is which. This helps reduce confusion and lessens the risk of entering test data into Production.

Whilst the core project team might easily remember which colour corresponds to which environment (e.g. blue=Prod, red=Dev, green=Test) it’s not so easy for more occasional users. There is a solution for this.

We’ve created some semi-transparent backgrounds that prominently feature (more...)

CSV parsing and tokenizing strings

Most of you will be familiar with the “Comma Separated Values” data format. It is used in spreadsheets and other places to store ordered lists of character data. The delimiter is typically a comma and if a comma is in a list item the item as a whole needs to be quoted, typically with double quotes.



is actually just three items


Also, if we wish to include a double-quote in (more...)

Optimistic Locking with one Timestamp?

A reader called chris asked me a good question about optimistic locking: why not use a “user-defined” scn (e.g. timestamp) as an extra column to achieve the same goal as ORA_ROWSCN? Well, chris, you'd have to use one per row, not one per transaction.

More on Optimistic Locking with ORA_ROWSCN

Thanks to comments by Tony Hasler and pingbacks from Jeff Kemp, here's more detail on how optimistic locking works with SCNs, especially with respect to "restarts" during update.

Optimistic Locking: One SCN to rule them all

Previously I showed how to avoid lost updates with ORA_ROWSCN. Now let’s create an API that avoids lost updates with just one SCN. What kind of API? A transaction consists of one or more changes to data that should happen together: either all should happen or none. When the transaction commits, all the changes happen; […]

I Am Speaking at OTN Yathra 2017

RSS content

The Oracle ACE directors and Oracle Volunteers  in the region are organizing their third evangelist event called ‘OTNYathra 2017’ during the month of June 2017 in a time period of 3 weeks. This yathra, managed by ACE directors and Oracle Volunteers of the region, is to travel across the country covering over six major IT focused cities (Chennai, Bangalore, Hyderabad,  Pune, Mumbai and Gurgaon) . It aims  to bring the Oracle community together, giving them awareness (more...)

EBS 12.1.3 Data masking issue with

I tried to data mask the EBS 12.1.3 data with database version but After i masked, I can’t open the application because of SYSADMIN and Guest user was missed. So I raised SR, As per support we need to upgrade database version to otherwise we need to do backport activity. If your database version is, you need to check with Oracle (more...)



The post SQL FUNDAS appeared first on DBACLASS.

Cedar’s Oracle Talent Acquisition Cloud Event / Team

Earlier this week Cedar held its Oracle Talent Acquisition Cloud event in Oracle’s London City office. We have a really strong team of UK-based Talent Acquisition specialists within our ranks:

Taleo Team 2 (plain background)

Jo, Prachi, Marc and Mel are all experts in the various aspects of Oracle Talent Aquisition Cloud – Taleo Recruit, Sourcing and Onboarding – and Cedar has multiple implementations under our belt covering all of the above products, so we were able to put on (more...)

DOAG Exaday 2017: a preview

I am quite excited to have been accepted to speak at the upcoming DOAG Exaday taking place June 20 in Frankfurt. It is the third time I have been lucky enough to present at the event, having spoken both in Frankfurt in Hamburg in previous years.

As you can probably imagine by looking at this weblog, I am a great supporter of the Oracle Engineered Systems community. My interest is not limited to Germany: I still remember (more...)

Question: Table names singular or plural?

Yesterday I put a question on twitter, to find out what others prefer: table names using singular or plural form. I expected one or two replies, not an avalanche :-)

As expected there were all kind of replies going either singular or plural. Some (more...)

toad and oracle client are getting ora-12560 tns protocol adapter error after upgraded windows 10

Yesterday morning I came to office, One of my colleague complaint, My toad not working , I am getting “ora-12560 tns protocol adapter error” while connecting to target database through toad.

I asked him when was this issue started , He said, After upgraded my pc to windows 10. I am getting this issue. I told him, My pc also upgraded to windows 10 but I am not getting this issue. I can able to (more...)

benchmarking your disks


While at Delphix, we did a lot of storage benchmarking. The I/O response times of Delphix depends, as one would logically imagine, heavily on the underlying disks. Sure Delphix can cache a lot ( with 1 TB of ram and 3x compression that’s 3TB and that 3TB can be shared by 10 or a 100 copies being the equivalent to 30TB or 300TB of databases) but really there will always be important I/O coming (more...)

Should you learn Spring or Oracle ADF?

My answer on Quora to “Should I learn Spring or Oracle ADF?”:

Oracle ADF is a specialty skill, Java Spring is a general skill. Java Spring should be your default choice, unless:

  1. You work in an company that has made Oracle ADF their strategic choice, or
  2. You come from a 4GL tool like Oracle Forms and don’t know much Java yet

With ADF, you get higher productivity but less control. It was created by (more...)

Speaking at DOAG and RMOUG rocked

As I wrote a while back I was accepted to speak both at the User Group Leader summit at DOAG16 and at RMOUG Training Days.

The first one was a short presentation where I talked about a large bug in Oracle security and the need to patch and upgrade to not have that exposure. It was great fun as it was limited to a four-minute talk. I learned a lot from preparing for it as (more...)

Remove OEM 13c Management Repository


Removing the SYSMAN schema and other OEM-related objects from a database consisted of disabling constraints and running a series of DDL scripts in earlier versions of OEM.  Always use RepManager to perform this cleanup for OEM 13c.

RepManager ‘-drop’ command drops the SYSMAN, SYSMAN_MDS, SYSMAN_OPSS, SYSMAN_RO, and SYSMAN_BIPLATFORM schemas and removes their artifacts, including tablespaces and datafiles.


Note:  The following run-time example has been simplified from actual stdout and uses a reference to $MW_HOME (more...)

Best of Both Worlds with ADF

I’m seeing a lot of interest in developing client-side applications based on one JavaScript framework or another. Today, the leading contenders are AngularJS (the old version) and Angular2 (the new version, of course, incompatible with the old). Oracle is also entering the game with Oracle JET.

For some strange reason, developers tend to compare Javascript frameworks to full stack frameworks like ADF, forgetting that someone, somewhere, must build the REST web services that JavaScript applications (more...)

Get your virtual mojo on

I have for a few years created a play environment in a similar way. Getting a database installed in a VM is not too hard. But I found that I did it fairly often and not always in the same way and not always without having to resolve problems I know I had solved before but since forgotten the solution for.

Right, write everything down. Yes, it was time for that.

So I now have (more...)