List of Tables

Beta Draft

• 2-1 Schema Objects in Oracle and Microsoft SQL Server
• 2-2 Data Types in Oracle and Microsoft SQL Server
• 2-3 Data Type Conversion for NULL Values
• 2-4 Data Storage Concepts in Oracle and Microsoft SQL Server
• 2-5 Connecting to the Database in Oracle and Microsoft SQL Server
• 2-6 SELECT Statements in Oracle and Microsoft SQL Server
• 2-7 SELECT with GROUP BY Statement in Oracle and Microsoft SQL Server
• 2-8 INSERT Statement in Oracle and Microsoft SQL Server
• 2-9 UPDATE Statement in Oracle and Microsoft SQL Server
• 2-10 DELETE Statement in Oracle and Microsoft SQL Server
• 2-11 Comparison Operators in Oracle and Microsoft SQL Server
• 2-12 Changing NULL Constructs
• 2-13 Arithmetic Operators in Oracle and Microsoft SQL Server
• 2-14 String Operators in Oracle and Microsoft SQL Server
• 2-15 Set Operators in Oracle and Microsoft SQL Server
• 2-16 Bit Operators in Oracle and Microsoft SQL Server
• 2-17 Character Functions in Oracle and Microsoft SQL Server
• 2-18 Comparison Operators in Oracle and Microsoft SQL Server
• 2-19 Date Functions in Oracle and Microsoft SQL Server
• 2-20 Mathematical Functions in Oracle and Microsoft SQL Server
• 2-21 Locking in Oracle and Microsoft SQL Server
• 2-22 Row-Level Versus Page-Level Locking in Oracle and Microsoft SQL Server
• 2-23 Read Consistency in Oracle and Microsoft SQL Server
• 2-24 Logical Transaction Handling in Oracle and Microsoft SQL Server
• 3-1 Composite Data Types in Oracle
• 3-2 Comparison of Creating the Procedure Schema Object in Oracle and Microsoft SQL Server
• 3-3 Comparison of Dropping the Procedure Schema Object in Oracle and Microsoft SQL Server
• 3-4 Comparison of Executing the Procedure Schema Object in Oracle and Microsoft SQL Server
• 3-5 Comparison of Altering the Procedure Schema Object in Oracle and Microsoft SQL Server
• 3-6 Comparison of Creating the Function Schema Object in Oracle and Microsoft SQL Server
• 3-7 Comparison of Dropping the Function Schema Object in Oracle and Microsoft SQL Server
• 3-8 Comparison of Executing the Function Schema Object in Oracle and Microsoft SQL Server
• 3-9 Comparison of Altering the Function Schema Object in Oracle and Microsoft SQL Server 7.0
• 3-10 Comparison of Creating the Package Schema Object in Oracle and Microsoft SQL Server
• 3-11 Comparison of Dropping the Package Schema Object in Oracle and Microsoft SQL Server
• 3-12 Comparison of Altering the Package Schema Object in Oracle and Microsoft SQL Server
• 3-13 Comparison of Creating the Package Body Schema Object in Oracle and Microsoft SQL Server
• 3-14 Comparison of Dropping the Package Body Schema Object in Oracle and Microsoft SQL Server
• 3-15 Comparison of Altering the Package Body Schema Object in Oracle and Microsoft SQL Server
• 3-16 Comparison of CREATE PROCEDURE Statement in Oracle and Microsoft SQL Server
• 3-17 Comparison of Parameter Passing in Oracle and Microsoft SQL Server
• 3-18 Comparison of DECLARE Statement in Oracle and Microsoft SQL Server
• 3-19 Comparison of IF Statement in Oracle and Microsoft SQL Server
• 3-20 Comparison of RETURN Statement in Oracle and Microsoft SQL Server
• 3-21 Comparison of RAISERROR Statement in Oracle and Microsoft SQL Server
• 3-22 Comparison of EXECUTE Statement in Oracle and Microsoft SQL Server
• 3-23 Comparison of WHILE Statement in Oracle and Microsoft SQL Server
• 3-24 Comparison of GOTO Statement in Oracle and Microsoft SQL Server
• 3-25 Comparison of @@Rowcount and @@Error Variables in Oracle and Microsoft SQL Server
• 3-26 Comparison of ASSIGNMENT Statement in Oracle and Microsoft SQL Server
• 3-27 Comparison of SELECT Statement in Oracle and Microsoft SQL Server
• 3-28 Comparison of SELECT Statement with GROUP BY Clause in Oracle and Microsoft SQL Server
• 3-29 Comparison of Column Aliases in Oracle and Microsoft SQL Server
• 3-30 Comparison of UPDATE with FROM Statement in Oracle and Microsoft SQL Server
• 3-31 Comparison of DELETE with FROM Statement in Oracle and Microsoft SQL Server
• 3-32 Comparison of Temporary Tables in Oracle and Microsoft SQL Server
• 3-33 Comparison of Cursor Handling Result Set in Oracle and Microsoft SQL Server
• 3-34 Comparison of Transaction-Handling Statements in Oracle and Microsoft SQL Server
• 3-35 Conversion Strategy for Transaction-Handling Statements
• 5-1 Location and Name of Script Files and Name of Associated Files