day : 22/10/2018 2 results

Oracle Pivoting Queries in TeamSQL

ORACLE PIVOTING QUERIES IN TEAMSQL One interesting feature in Oracle is the PIVOT operator, which is available from Oracle version 11g. This feature is frequently used in data warehouse environments to solve cross queries in few lines of SQL code. In this article, we will explain how to use the PIVOT clause in Oracle to create powerful cross queries using TeamSQL. First of all, what are cross queries or pivot tables ?. A pivot table is a table of statistics that summarize the data of a ...

The Difference Between SQL and PL/SQL

If you’re familiar with Oracle Databases, you’ll have seen mentions to SQL and PL/SQL, which are both programming languages used to interact with said databases. In this article, we will cover what these two programming languages are, as well as when you should use which. SQL 101 When it comes to databases, SQL is the industry-standard programming language developers use to: Create, modify, or delete database objects Query, insert, update, or delete data into database objects...