-----------------------------------------------------------
New Message on BDOTNET
-----------------------------------------------------------
From: convertor00
Message 2 in Discussion
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
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
-----------------------------------------------------------
To stop getting this e-mail, or change how often it arrives, go to your E-mail
Settings.
http://groups.msn.com/BDOTNET/_emailsettings.msnw
Need help? If you've forgotten your password, please go to Passport Member
Services.
http://groups.msn.com/_passportredir.msnw?ppmprop=help
For other questions or feedback, go to our Contact Us page.
http://groups.msn.com/contact
If you do not want to receive future e-mail from this MSN group, or if you
received this message by mistake, please click the "Remove" link below. On the
pre-addressed e-mail message that opens, simply click "Send". Your e-mail
address will be deleted from this group's mailing list.
mailto:[EMAIL PROTECTED]
