Articles


2014-03-06

This article will convince database developers that types in the Oracle

Full article

2014-06-01

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 through different pages. Is this possible using plain SQL?

Full article   Read at blog.bar-solutions.com

2014-09-01

Could you tell me what the difference is between NVL and COALESCE?

Full article   Read at blog.bar-solutions.com

2014-12-01

What is an ANTI-JOIN? And what is the difference between the SEMI-JOIN and the ANTI-JOIN?

Full article   Read at blog.bar-solutions.com

2015-03-06

Last year I did a presentation on table functions at KScope. One of the questions I got was: ‘If pipelined table functions provide their results faster, why would you want to use a normal table function?’ I couldn’t come up with the answer then, maybe you can help?

Full article   Read at blog.bar-solutions.com

2015-06-01

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?

Full article   Read at blog.bar-solutions.com

2015-09-01

We have bought an application that runs on an Oracle database. There are triggers defined on the tables, but we want to add our own code to these triggers, but we don’t have access to the source code. What is the approach we should follow to accomplish this?

Full article   Read at blog.bar-solutions.com

2015-12-31

We have gone through a merger at our company where we are trying to merge the databases. The problem now is that we have duplicate records in our tables. We can of course go through all the records by hand and check if they exist twice. Another option is to build an application to do this. But using the Oracle Database there must be a better way to do this.

Full article   Read at blog.bar-solutions.com


Copyright © Bar Solutions 2003 - 2016