0
| Terminology | Oracle | SQL Server |
| schema | database | |
| service name | database name | |
| System ID (SID) | database name | |
| Storage | block | page |
| Extent | user-defined | fixed at 8 pages |
| Storage management pages (SMP) | dictionary or local | local only |
| Metadata | data dictionary | SYS database |
| Recursive SQL | connect by clause | HierarchyID data type |
| Language | PL/SQL | T-SQL |











0Awesome Comments!