1 SQL Server SQL Oracle SQL SQL* Plus PL/SQL 2 SQL Server SQL Server SQL Oracle SQL SQL*Plus SQL Server GUI 1-1 osql 1-1 Transact- SQL SELECTFROM 058
2 Excel 1 SQL 1 SQL Server sp_executesql Oracle SQL Oracle SQL PL/SQL SQL Server 2 1 059
1 SQL Server osql GO 1 EXECUTE sp_executesql CREATE DEFAULTCREATE PROCEDURECREATE RULECREATE TRIGGERCREATE VIEW CREATE CREATE CREATE EXECUTE EXECUTE EXECUTE EXECUTE Oracle SQL schema.objectname@netservicename netservicename SID @netservicename SQL Server < >. < >. < >. < > 060
2 server01 keiridbuser1 uriage server01.keiridb.user1.uriage dbo SQL Server Oracle dbo Oracle SQL Server 1-2 1 Oracle SQL Server DB_A DB_B A B 1-2 SQL Server Oracle SQL Server int bigint -2 63-9,223,372,036,854,775,808 2 63-19,223,372,036,854,775. 807 2 1 061
int int -2 31-2,147,483,648 2 31-12, 147,483,647 smallint tinyint -2 15-32,768 2 15-132,767 0 255 bit bit 1 0 decimal decimal -10 38 +1 10 38-1 numeric numeric decimal money money 10,000 1 smallmoney -2 63-922,337,203,685,477. 5808 2 63-1+922,337,203,685, 477.5807 smallmoney 10,000 1-214,748.3648 +214,748. 3647 float -1.79E+ 308 1.79E + 308 real -3.40E + 38 3.40E + 38 datetime 300 1 3.33 1753 1 1 9999 12 31 smalldatetime 1900 1 1 2079 6 6 char 8,000 Unicode varchar text 8,000 Unicode 2 31-12,147,483,647 Unicode 062
2 Unicode nchar 4,000 Unicode nvarchar ntext 4,000 Unicode sys name nvarchar128 2 30-11,073,741,823 Unicode binary 8,000 varbinary 8,000 image 2 31-12,147,483,647 cursor sql_variant table timestamp uniqueidentifier text ntext timestamp sql_ variant SQL Server GUID 1 SQL Server @ DECLARE SET @x @y int 100 500 2 1 063
DECLARE @x int, @y int SET @x = 100 SET @y = 500 SQL Serve @@ SQL Server 7.0 @@ERROR Oracle PL/SQL EXCEPTION SQL Server @@error @@IDENTITY INSERT ID IDENTITY @@ROWCOUNT @@TRANCOUNT SQL Oracle SQL Server SQL SQL SQL Server DATEADDDATEDIFF DATENAMEDATEPARTDAYMONTHYEAR SQL Server Books Online Oracle SYSDATE SQL Server GETDATE 2 Oracle 2 4 RR YY 50 064
2 SQL Server 1 2 1-3 2 1950 2049 1 1-3 2 SQL Server Enterprise Manager FROM Oracle SELECT FROM DUAL SQL Server FROM SELECT GETDATE() PRINT SQL Server SET SELECT @x = 12345 Oracle SQL Server + employee fname lname SELECT fname + lname FROM employee 2 1 065
Oracle FROM WHERE SELECT CategoryName, ProductName FROM Categories C, Products P WHERE C.CategoryID = P.CategoryID AND ProductName = 'Ikura' SQL Server SELECT CategoryName, ProductName FROM Categories C INNER JOIN Products P ON C.CategoryID = P.CategoryID WHERE ProductName = 'Ikura' Oracle SELECT ProductName, Quantity FROM Products P, Orders O WHERE P.ProductID (+) = O.ProductID SQL Server Oracle (+) *= =* SQL-92 SELECT ProductName, Quantity FROM Products P LEFT OUTER JOIN Orders O ON P. ProductID = O.ProductID SQL SQL Server SQL SQL Oracle CREATE OR REPLACE OR REPLACE SQL Server OR REPLACE CREATE 066
2 IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = object_id('')) DROP TABALE Oracle ROWNUM ROWNUM WHERE SQL Server Oracle ROWNUM 1 SET ROWCOUNT n TOP SELECT Transact- SQL 10 SELECT TOP 10 * FROM orders ORDER BY quantity DESC WITH TIES 10 SELECT TOP 10 WITH TIES * FROM orders ORDER BY quantity DESC 1% SELECT TOP 1 PERCENT * FROM orders ORDER BY quantity DESC SQL Server BEGIN END SQL Server PRINT IF SQL 1 2 1 067
IF (SELECT AVG(price) FROM titles WHERE type = 'mod_cook') < $15 BEGIN PRINT 'The following titles are excellent mod_cook ' PRINT 'books: ' SELECT SUBSTRING(title, 1, 35) AS Title FROM titles WHERE type = 'mod_cook' END ELSE IF (SELECT AVG(price) FROM titles WHERE type = 'mod_cook') > $15 BEGIN PRINT 'The following titles are expensive mod_cook ' PRINT 'books: ' SELECT SUBSTRING(title, 1, 35) AS Title FROM titles WHERE type = 'mod_cook' END SQL Server temp ORDER BY # SQL Server temp ## SQL Server temp temp SELECT INTO Oracle CREATE TABLE AS SELECT 068
2 IDENTITY 1 Oracle SEQUENCE SQL Server IDENTITY IDENTITY order order_no 10000 5 CREATE TABLE orders (order_no INT IDENTITY(10000,5) NOT NULL order_date DATETIME NOT NULL customer VARCHER(50) NOT NULL) Oracle SQL Server Oracle SQL Server PRIMARY KEY UNIQUE UNIQUE NULL 1 DISABLEENABLE NOCHECK CHECK PRIMARY KEYUNIQUE CASCADE DEFAULT CHECK FOREIGN KEY Oracle SQL Server FOREIGN KEY CASCADE DELETE CASCADE DELETE CASCADE UPDATE 2 1 069