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

Size: px

Start display at page:

Download "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"

きみとしわしあし
5 years ago
Views:

2 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

3 2 Excel 1 SQL 1 SQL Server sp_executesql Oracle SQL Oracle SQL PL/SQL SQL Server

4 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 SQL Server < >. < >. < >. < > 060

5 2 server01 keiridbuser1 uriage server01.keiridb.user1.uriage dbo SQL Server Oracle dbo Oracle SQL Server Oracle SQL Server DB_A DB_B A B 1-2 SQL Server Oracle SQL Server int bigint ,223,372,036,854,775, ,223,372,036,854,

6 int int ,147,483, , 147,483,647 smallint tinyint , , bit bit 1 0 decimal decimal numeric numeric decimal money money 10,000 1 smallmoney ,337,203,685, ,337,203,685, smallmoney 10, , , float -1.79E E real -3.40E E + 38 datetime smalldatetime char 8,000 Unicode varchar text 8,000 Unicode ,147,483,647 Unicode 062

7 2 Unicode nchar 4,000 Unicode nvarchar ntext 4,000 Unicode sys name nvarchar ,073,741,823 Unicode binary 8,000 varbinary 8,000 image ,147,483,647 cursor sql_variant table timestamp uniqueidentifier text ntext timestamp sql_ variant SQL Server GUID 1 SQL int

8 int = 100 = 500 SQL SQL Server Oracle PL/SQL EXCEPTION INSERT 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

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

9 2 SQL Server SQL Server Enterprise Manager FROM Oracle SELECT FROM DUAL SQL Server FROM SELECT GETDATE() PRINT SQL Server SET = Oracle SQL Server + employee fname lname SELECT fname + lname FROM employee

10 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

11 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

12 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

13 2 IDENTITY 1 Oracle SEQUENCE SQL Server IDENTITY IDENTITY order order_no 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

橡実践Oracle Objects for OLE

橡実践Oracle Objects for OLE THE Database FOR Network Computing 2 1. 2 1-1. PL/SQL 2 1-2. 9 1-3. PL/SQL 11 2. 14 3. 16 3-1. NUMBER 16 3-2. CHAR/VARCHAR2 18 3-3. DATE 18 4. 23 4-1. 23 4-2. / 24 26 1. COPYTOCLIPBOARD 26 III. 28 1.