SQL Server and Oracle Comparison

Learn how to automate an Oracle Table Space report from SQL Server with a Linked Server, Tables, Stored Procedures and SQL Server Agent Job.

Learn about database administration tools that are similar between SQL Server and Oracle.

I am working on both SQL Server and Oracle databases. I know many of the concepts are the same, but I am not sure how to build the code I need to complete my daily tasks. Can you provide some insight into SQL Server vs. Oracle?

In this tip we are going to compare the SQL Server (T-SQL) and Oracle (PL-SQL) extensions of the SQL language. The tip will compare both T-SQL and PL-SQL languages with respect to retrieving data, creating databases, tables, variables, etc.

There are several terms that are similar in SQL Server and Oracle. However, there are other terms that are different and require some clarification. This tip was written to clarify terms in Oracle and SQL Server for users who need to work in both worlds.

As I mentioned in a previous tip, that compared datatypes between SQL Server and Oracle, given that I've worked with both technologies I constantly find myself thinking in terms of one and comparing it to something in the other. This tip will give an over