--fred
differences in managing users
last updated: 6/6/1999
applies to: oracle 7.3+, ms sql server 6.5+
the following table shows some differences in how users are managed in oracle and ms sql server:
| description | oracle | ms sql server |
|---|---|---|
| membership in groups | each user can be a member of any number of groups. | each user can be a member of only one group other than "public". |
--fred
differences in integration with ms ado, rdo, etc.
last updated: 6/6/1999
applies to: oracle 7.3+, ms sql server 6.5+
the following table shows the different techniques used in oracle and ms sql server to interact with ms ado, rdo, etc.:
| description | oracle | ms sql server |
|---|---|---|
| return a recordset to the caller | return a handle to a cursor. for more info: see ms kb article q174679. |
select with no into clause; multiple such selects return multiple recordsets |
--fred
miscellaneous differences
last updated: 6/6/1999
applies to: oracle 7.3+, ms sql server 6.5+
the following table shows miscellaneous differences between oracle and ms sql server:
| description | oracle | ms sql server |
|---|---|---|
| generate unique numbers | create sequence | identity column of a table |
| cascaded delete | delete cascade ... | (use triggers) |
| call a user-defined function from a sql statement (as column of select or expression in where clause) | supported | not supported |
