Blog: Patrick Barel

208 blogs updated: 8 min. ago
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...
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...
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...
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-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...
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...
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...
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 ...
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...
08-09-2016 12:21:27 Patrick Barel Oracle
How do I get my query results paginated?
Dear Patrick, I have got a website with a search form. I want to display a limited number of results to the user and have him/her navigate t...
01-09-2016 11:41:29 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.