T-SQL vs PL/SQL
The dialect of SQL supported by Microsoft SQL Server 2000 is called Transact-SQL (T-SQL). The dialect of SQL supported by Oracle 9i Database is called PL/SQL. PL/SQL is more powerful language than T-SQL. This is the brief comparison of PL/SQL and T-SQL:
| Feature |
PL/SQL |
T-SQL |
| Indexes |
B-Tree indexes,
Bitmap indexes,
Partitioned indexes,
Function-based indexes,
Domain indexes |
B-Tree indexes |
| Tables |
Relational tables,
Object tables,
Temporary tables,
Partitioned tables,
External tables,
Index organized tables |
Relational tables,
Temporary tables |
| Triggers |
BEFORE triggers,
AFTER triggers,
INSTEAD OF triggers,
Database Event triggers |
AFTER triggers,
INSTEAD OF triggers |
| Procedures |
PL/SQL statements,
Java methods,
third-generation language
(3GL) routines |
T-SQL statements |
| Arrays |
Supported |
Not Supported |
SQL Server 2000 and Oracle 9i limits
Here you can find some SQL Server 2000 and Oracle 9i Database limits:
| Feature |
SQL Server 2000 |
Oracle 9i Database |
| database name length |
128 |
8 |
| column name length |
128 |
30 |
| index name length |
128 |
30 |
| table name length |
128 |
30 |
| view name length |
128 |
30 |
| stored procedure name length |
128 |
30 |
| max columns per index |
16 |
32 |
| max char() size |
8000 |
2000 |
| max varchar() size |
8000 |
4000 |
| max columns per table |
1024 |
1000 |
| max table row length |
8036 |
255000 |
| max query size |
16777216 |
16777216 |
| recursive subqueries |
40 |
64 |
| constant string size in SELECT |
16777207 |
4000 |
| constant string size in WHERE |
8000 |
4000 |
Conclusion
It is not true that SQL Server 2000 is better than Oracle 9i or vice versa. Both products can be used to build stable and efficient system and the stability and effectiveness of your applications and databases depend rather from the experience of the database developers and database administrator than from the database's provider. But SQL Server 2000 has some advantages in comparison with Oracle 9i and vice versa.
The SQL Server 2000 advantages:
- SQL Server 2000 is cheaper to buy than Oracle 9i Database.
- SQL Server 2000 holds the top TPC-C performance and price/performance results.
- SQL Server 2000 is generally accepted as easier to install, use and manage.
The Oracle 9i Database advantages:
- Oracle 9i Database supports all known platforms, not only the Windows-based platforms.
- PL/SQL is more powerful language than T-SQL.
- More fine-tuning to the configuration can be done via start-up parameters
|
