Differences

This shows you the differences between two versions of the page.

oracle [December 21, 2017 6:31 am]
sqlines
oracle [November 19, 2020 9:39 pm] (current)
sqlines
Line 1: Line 1:
-====== Oracle Reference ======+====== Oracle Migration Reference ======
-Technical information on Oracle database.+Technical information on migration to/from Oracle database. 
 + 
 +  * [[/oracle#identifiers|Identifiers]] 
 +  * [[/oracle#built-in-functions|Built-in Functions]]
Line 9: Line 12:
===== Identifiers ===== ===== Identifiers =====
-Names for database objects such as databases, tables, views, columns, indexes, triggers, procedures etc.+Names for database objects, columns, variables etc.
| First character | Alphabetical || | First character | Alphabetical ||
Line 22: Line 25:
| Database links | 128 | | Database links | 128 |
-Namespace:+Namespaces:
-| Unique within the schema | Constraints | +| Table constraints names | Must be unique within the schema {{:exclamation.png|}} |
- +
-===== Environment and Configuration ===== +
- +
-  * [[/oracle/character_sets_length_semantics|Character Sets and Length Semantics]] +
-  * [[/oracle/date_timestamp_formats|Date and Timestamp Formats]] +
- +
- +
- +
-===== Physical Database Design ===== +
- +
-  * [[oracle_schema_sql_server_database|Oracle Schema to SQL Server Database Mapping (Oracle Tablespaces and SQL Server Filegroups)]]+
===== Database Schema Objects ===== ===== Database Schema Objects =====
Line 47: Line 39:
| [[oracle/function_based_indexes|Function-Based Indexes]] | [[oracle/function_based_indexes|Indexes on Computed Columns and Collation for Case-Insensitive Search]] | | [[oracle/function_based_indexes|Function-Based Indexes]] | [[oracle/function_based_indexes|Indexes on Computed Columns and Collation for Case-Insensitive Search]] |
| [[oracle/statements/create_trigger|Triggers]] | PL/SQL to Transact-SQL conversion, significant redesign {{:exclamation.png|}} | | [[oracle/statements/create_trigger|Triggers]] | PL/SQL to Transact-SQL conversion, significant redesign {{:exclamation.png|}} |
- 
- 
- 
-===== Data ===== 
- 
-Data migration issues from Oracle to SQL Server: 
- 
-  * [[/oracle/trailing_spaces_pk_columns|Trailing Spaces in Primary Key Columns]] 
-  * [[/oracle/case_sensitivity_primary_key|Case Sensitivity Issues in Primary Keys]] 
-  * [[/oracle/insert_empty_string_to_fk_column|Inserting Empty String to a Foreign Key Column]] 
-  * [[/oracle/insert_empty_string_to_numeric_column|Inserting Empty String to a Numeric Column]] 
- 
- 
===== SQL and PL/SQL Language Elements ===== ===== SQL and PL/SQL Language Elements =====
Line 78: Line 57:
===== Built-in Functions ===== ===== Built-in Functions =====
-Converting built-in SQL functions:+Built-in SQL functions:
| **Oracle** || **SQL Server** || | **Oracle** || **SQL Server** ||
Line 96: Line 75:
| TRIM | Trim leading or trailing characters | LTRIM and RTRIM || | TRIM | Trim leading or trailing characters | LTRIM and RTRIM ||
| [[oracle/functions/unistr|UNISTR]] | Convert Unicode code points to characters | [[oracle/functions/unistr|Expressions using NCHAR]] || | [[oracle/functions/unistr|UNISTR]] | Convert Unicode code points to characters | [[oracle/functions/unistr|Expressions using NCHAR]] ||
 +
Line 131: Line 111:
| 1 | [[oracle/ora-00001|ORA-00001]] | Unique constraint violated | [[oracle/ora-00001|Msg 2627, Level 14]] | | 1 | [[oracle/ora-00001|ORA-00001]] | Unique constraint violated | [[oracle/ora-00001|Msg 2627, Level 14]] |
 +===== Environment and Configuration =====
 +
 +  * [[/oracle/character_sets_length_semantics|Character Sets and Length Semantics]]
 +  * [[/oracle/date_timestamp_formats|Date and Timestamp Formats]]
 +
 +
 +===== Data =====
 +
 +Data migration issues from Oracle to SQL Server:
 +
 +  * [[/oracle/trailing_spaces_pk_columns|Trailing Spaces in Primary Key Columns]]
 +  * [[/oracle/case_sensitivity_primary_key|Case Sensitivity Issues in Primary Keys]]
 +  * [[/oracle/insert_empty_string_to_fk_column|Inserting Empty String to a Foreign Key Column]]
 +  * [[/oracle/insert_empty_string_to_numeric_column|Inserting Empty String to a Numeric Column]]
 +
 +===== Physical Database Design =====
 +
 +  * [[oracle_schema_sql_server_database|Oracle Schema to SQL Server Database Mapping (Oracle Tablespaces and SQL Server Filegroups)]]