Blog: Patrick Barel


209 blogs updated: 79 min. ago
Comparing queries…
How do you compare a rewritten query to its original version? Most of the time I just run a MINUS operation on the original and new query. A...
4
22-10-2017 09:57:52 Patrick Barel Oracle
Change UUIDs in VirtualBox
If you are anything like me you will have multiple virtualboxes running on your system. Sometimes you might want to run a copy of a virtualb...
4
12-03-2017 08:29:47 Patrick Barel Oracle
Connecting PL/SQL Developer
In SQL Developer you have a lot of options when connecting to the database. You can use the TNS entries defined but you can also give the ho...
9
28-10-2016 17:29:04 Patrick Barel Oracle
How can we use Oracle to deduplicate our data
Dear Patrick, We have gone through a merger at our company where we are trying to merge the databases. The problem now is that we have dupli...
6
13-10-2016 12:39:31 Patrick Barel Oracle
OTN Appreciation Day : Prebuilt Developer VMs
I learnt a lot from the entire Oracle Technology Network and I still do. One of the best features of OTN these days, IMHO, is the ability to...
11
11-10-2016 13:08:42 Patrick Barel Oracle
How can we add custom code to existing triggers?
Dear Patrick, We have bought an application that runs on an Oracle database. There are triggers defined on the tables, but we want to add ou...
4
06-10-2016 13:06:17 Patrick Barel Oracle
What is overloading and how and when do I use it
Dear Patrick, Recently I heard someone talk about overloading in Java. What is it, is it possible in PL/SQL and if so, how would I use it? R...
6
29-09-2016 11:40:56 Patrick Barel Oracle
When would you use a normal table function?
Dear Patrick, Last year I did a presentation on table functions at KScope. One of the questions I got was: 'If pipelined table functions pro...
6
22-09-2016 12:29:42 Patrick Barel Oracle
What's the difference between SEMI-JOIN and ANTI-JOIN?
Dear Patrick, What is an ANTI-JOIN? And what is the difference between the SEMI-JOIN and the ANTI-JOIN? Lillian Sturdey Dear Lillian, First ...
11
15-09-2016 12:27:42 Patrick Barel Oracle
What is the difference between NVL and COALESCE?
Dear Patrick, Could you tell me what the difference is between NVL and COALESCE? Kindest regards, Paul McCurdey Dear Paul, NVL returns the v...
14
08-09-2016 12:21:27 Patrick Barel Oracle


© Jiri Pinkas | this project on GitHub | related: SQL školení | Top Java Blogs | monitored using: sitemonitoring

Top SQL Blogs is a blog aggregator (with English-written blogs only) focused on MySQL, PostgreSQL, MS-SQL and Oracle databases.