1/10
Contents
List of Tables
Title and Copyright Information
Preface
Intended Audience
Documentation Accessibility
What You Should Already Know
Related Documents
Conventions
1
Overview
1.1
Introduction
1.2
Product Description
1.3
Features
1.4
Glossary
2
Microsoft SQL Server, Sybase Adaptive Server, and Oracle Compared
2.1
Schema Migration
2.1.1
Schema Object Similarities
2.1.2
Schema Object Names
2.1.3
Table Design Considerations
2.1.3.1
Data Types
2.1.3.2
Entity Integrity Constraints
2.1.3.3
Referential Integrity Constraints
2.1.3.4
Unique Key Constraints
2.1.3.5
Check Constraints
2.2
Data Types
2.2.1
Data Types Table
2.3
Data Storage Concepts
2.3.1
Data Storage Concepts Table
2.4
Data Manipulation Language
2.4.1
Connecting to the Database
2.4.2
SELECT Statement
2.4.2.1
SELECT Statements without FROM Clauses:
2.4.2.2
SELECT INTO Statement:
2.4.2.3
Column Aliases:
2.4.2.4
Table Aliases:
2.4.2.5
Compute:
2.4.3
SELECT with GROUP BY Statement
2.4.4
INSERT Statement
2.4.5
UPDATE Statement
2.4.5.1
Method 1 - Convert UPDATE statements with FROM clauses:
2.4.5.2
Method 2 - Convert UPDATE statements with FROM clauses:
2.4.6
DELETE Statement
2.4.6.1
Remove Second FROM Clause:
2.4.7
Operators
2.4.7.1
Comparison Operators
2.4.7.2
Arithmetic Operators
2.4.7.3
String Operators
2.4.7.4
Set Operators
2.4.7.5
Bit Operators
2.4.8
Built-In Functions
2.4.8.1
Character Functions
2.4.8.2
Miscellaneous Functions
2.4.8.3
Date Functions
2.4.8.4
Mathematical Functions
2.4.9
Locking Concepts and Data Concurrency Issues
2.4.9.1
Locking
2.4.9.2
Row-Level Versus Page-Level Locking
2.4.9.3
Read Consistency
2.4.9.4
Logical Transaction Handling
3
Triggers and Stored Procedures
3.1
Triggers
3.2
Stored Procedures
3.2.1
Individual SQL Statements
3.2.1.1
Microsoft SQL Server or Sybase Adaptive Server:
3.2.1.2
Oracle:
3.2.1.3
Microsoft SQL Server or Sybase Adaptive Server:
3.2.1.4
Oracle:
3.2.2
Logical Transaction Handling
3.2.2.1
Transaction-Handling Statements
3.2.3
Error Handling Within the Stored Procedure
3.2.3.1
RAISERROR Statement
3.2.3.2
Customized Error Messages
3.3
Data Types
3.3.1
Local Variable
3.3.2
Server Data Types
3.3.3
Composite Data Types
3.4
Schema Objects
3.4.1
Procedure
3.4.1.1
Create
3.4.1.2
Drop
3.4.1.3
Execute
3.4.1.4
Alter
3.4.2
Function
3.4.2.1
Create
3.4.2.2
Drop
3.4.2.3
Execute
3.4.2.4
Alter
3.4.3
Package
3.4.3.1
Create
3.4.3.2
Drop
3.4.3.3
Alter
3.4.4
Package Body
3.4.4.1
Create
3.4.4.2
Drop
3.4.4.3
Alter
3.5
T/SQL Versus PL/SQL Constructs
3.5.1
CREATE PROCEDURE Statement
3.5.2
Parameter Passing
3.5.3
DECLARE Statement
3.5.4
IF Statement
3.5.5
RETURN Statement
3.5.6
RAISERROR Statement
3.5.7
EXECUTE Statement
3.5.8
WHILE Statement
3.5.9
GOTO Statement
3.5.10
@@Rowcount and @@Error Variables
3.5.11
ASSIGNMENT Statement
3.5.12
SELECT Statement
3.5.13
SELECT Statement with GROUP BY Clause
3.5.14
Column Aliases
3.5.15
UPDATE with FROM Statement
3.5.16
DELETE with FROM Statement
3.5.17
Temporary Tables
3.5.18
Cursor Handling
3.6
T/SQL and PL/SQL Language Elements
3.6.1
Transaction Handling Semantics
3.6.1.1
Conversion Preparation Recommendations
3.6.2
Exception-Handling and Error-Handling Semantics
3.6.3
Special Global Variables
3.6.4
Operators
3.6.5
Built-in Functions
3.6.6
DDL Constructs within Microsoft SQL Server or Sybase Adaptive Server Stored Procedures
4
Distributed Environments
4.1
Distributed Environments
4.1.1
Accessing Remote Databases in a Distributed Environment
4.1.1.1
Oracle and Remote Objects
4.1.2
Microsoft SQL Server or Sybase Adaptive Server and Remote Objects
4.1.3
Replication
4.2
Application Development Tools
5
Disconnected Source Model Loading
5.1
Generating Database Metadata Flat Files
5.1.1
Flat File Generation Scripts
5.1.1.1
Running the Scripts
Index
Scripting on this page enhances content navigation, but does not change the content in any way.