(Robyn Lorusso and Tim DiChiara) Can a SQL Server fan be converted to Oracle DBMS? Not easily. The loyalty which database administrators feel for their database vendor borders on the fanatical. It’s a love-hate relationship, where only those using Oracle, for example, are allowed to complain about O

The start with connect by clause can be used to select data that has a hierarchical relationship (usually some sort of parent->child (boss->employee or thing->parts). It is also being used when an sql execution plan is explained.

(Sanjay Mishra) Most decision support systems usually involve large amounts of data stored in a few very large tables. As these systems evolve, the demand on disk space can grow quickly. In today’s environment, data warehouses of hundreds of terabytes have become increasingly common. To help man

(Galina Petrenko) This technique presents conversion of the result of subtraction between dates. For example, I am looking for how many days, hours, minutes, etc. elapsed between two dates. Oracle Database is returning the result in days (such as 2.23456). The result is not exactly readable and has

Today, islands of computing within organizations make inefficient use of resources. Systems are slow to change and expensive to maintain. Grid computing addresses these problems by providing an adaptive software infrastructure that makes efficient use of low-cost servers and modular storage, whi

(James Koopmann) This article is the first in a three part series that will take you through the process of creating VARRAYs and dealing with them in Oracle tables.

(Ramesh Periyasamy) This function will split an input string separated by commas into a string enclosed with single quotes. This is helful in applying conditions in dynamic SQL.

(Allan Edwards) If you’re a DBA who has to tune the performance of a new system — and answer to users who scream when things slow down — you may sometimes curse the rise of multi-tiered architectures to replace traditional client/server systems. While multi-tiered architectures offer plenty of excit

(Steven Feuerstein) It is not hard to come up with a list of dos and don’ts for developers. This list can rather easily become completely overwhelming, however, because it can be (a) hard to remember all the best practices, (b) challenging to implement them, and (c) perplexing to determine whether o

(Mike Selvaggio) If you need to calculate working days between 2 dates and you can’t create the Oracle-recommended working days function, here is the SQL that can accomplish the same task.