Tuesday, 17 May 2016

Terminology Mapping between Oracle and SQL Server

TerminologyOracleSQL Server
   
 schemadatabase
 service namedatabase name
 System ID (SID)database name
Storageblockpage
Extentuser-definedfixed at 8 pages
Storage management pages (SMP)dictionary or locallocal only
Metadatadata dictionarySYS database
Recursive SQLconnect by clauseHierarchyID data type
LanguagePL/SQLT-SQL

No comments:

Post a Comment