All geek questions in one place

Difference between tsql, sql access and pl / sql

I am very confused

please help clarify these differences!

- are they all completely different languages? What is overlap?

+4
source share
3 answers

TSQL - Transact SQL
PL / SQL - SQL for Oracle SQL Server
Access SQL is a hacked version of SQL

TSQL and PL / SQL are based on the ISO / ANSI SQL standards. It depends on the version of SQL Server (TSQL) or Oracle (PL / SQL) for the version of ISO / ANSI that they use. See http://en.wikipedia.org/wiki/SQL for more details.

TSQL and PL / SQL have additional functionality beyond the ISO / ANSI SQL contributed by the companies that created them. In general, the ISO / ANSI SQL standard is specifically devoted to how you can query the database and what structures you can have in the database (for example, tables, triggers, stored procedures, etc.). TSQL and PL / SQL are true programming languages ​​because they can do loops and other things that programming languages ​​can do. Simply put, TSQL and PL / SQL are complete, and ISO standards are not.

I am not sure about Access. I think this is just a hacked version of SQL.

+5
source

T-SQL and PL / SQL are extensions to SQL. Overlap is completely dependent on which versions of Oracle and SQL Server you are comparing. IE:

With syntax: Oracle is supported since 9i - SQL Server support began in 2005.

ANSI-92 Support: Oracle 9i + vs SQL Server 2005 +

  • Analytics (ROW_NUMBER, RANK, DENSE_RANK)
  • CASE statement

Regular expression support: Oracle 10g + vs SQL Server 2005+ (requires the creation of CLR functions and the CLR function)

PIVOT / UNPIVOT: SQL Server 2005+ and Oracle 11g +

COALESCE: Oracle 9i + vs SQL Server 2000 +

+6
source

There are SQL standards that fit most RDBMSs, but in order to be competitive, most companies add their own extensions.

In many cases, these are extensions that simply do not conform to the standard.

+2
source

Source: https://habr.com/ru/post/1303293/

More articles:


All Articles