mysql - Oracle和MySQL的代码形式区别-6ren

mysql - Oracle和MySQL的代码形式区别

转载作者：行者123 更新时间：2023-11-29 05:50:33

我正在通过 http://www.sqlines.com/online 将 Oracle 中的代码转换为 MYSQL。代码在 Oracle 中完全正确(创建的表和数据没有任何错误消息)，但是当我复制代码并粘贴到 MYSQL 时出现错误消息:

SQL Error [1005] [HY000]: Can't create table universityddl.faculty (errno: 150 "Foreign key constraint is incorrectly formed").

我不明白是什么原因，因为我是 DBMS 的新手。如果有人可以提供帮助，我将不胜感激。

Oracle 中的代码:

CREATE TABLE Faculty ( 
    FacNo         CHAR(11)      NOT NULL, 
    FacFirstName  VARCHAR(30)   NOT NULL, 
    FacLastName   VARCHAR(30)   NOT NULL, 
    FacCity       VARCHAR(30)   NOT NULL, 
    FacState      CHAR(2)       NOT NULL, 
    FacDept       CHAR(6)       NULL, 
    FacRank       CHAR(4)       NULL, 
    FacSalary     DECIMAL(10,2) NULL, 
    FacSupervisor CHAR(11)      NULL, 
    FacHireDate   DATE      NULL, 
    FacZipCode    CHAR(10)      NOT NULL, 
    CONSTRAINT FacultyPK PRIMARY KEY (FacNo),  
    CONSTRAINT SupervisorFK FOREIGN KEY (FacSupervisor) REFERENCES Faculty
);

CREATE TABLE Course ( 
    CourseNo      CHAR(6)       NOT NULL, 
    CrsDesc       VARCHAR(50)   NOT NULL, 
    CrsUnits      INTEGER       NULL, 
    CONSTRAINT CoursePK PRIMARY KEY (CourseNo) 
);

CREATE TABLE Offering ( 
    OfferNo       INTEGER       NOT NULL, 
    CourseNo      CHAR(6)       NOT NULL, 
    OffTerm       CHAR(6)       NOT NULL, 
    OffYear       INTEGER       NOT NULL, 
    OffLocation   VARCHAR(30)   NULL, 
    OffTime       VARCHAR(10)   NULL, 
    FacNo         CHAR(11)      NULL, 
    OffDays       CHAR(4)       NULL, 
    CONSTRAINT OfferingPK PRIMARY KEY (OfferNo), 
    CONSTRAINT CourseFK FOREIGN KEY (CourseNo) REFERENCES Course, 
    CONSTRAINT FacultyFK FOREIGN KEY (FacNo) REFERENCES Faculty
);

CREATE TABLE Student ( 
    StdNo         CHAR(11)      NOT NULL, 
    StdFirstName  VARCHAR(30)   NOT NULL, 
    StdLastName   VARCHAR(30)   NOT NULL, 
    StdCity       VARCHAR(30)   NOT NULL, 
    StdState      CHAR(2)       NOT NULL, 
    StdZip        CHAR(10)      NOT NULL, 
    StdMajor      CHAR(6)       NULL, 
    StdClass      CHAR(2)       NULL, 
    StdGPA        DECIMAL(3,2)  NULL, 
    CONSTRAINT StudentPk PRIMARY KEY (StdNo) 
);

CREATE TABLE Enrollment( 
    OfferNo       INTEGER       NOT NULL, 
    StdNo         CHAR(11)      NOT NULL, 
    EnrGrade      DECIMAL(3,2)  NULL, 
    CONSTRAINT EnrollmentPK PRIMARY KEY (OfferNo,StdNo), 
    CONSTRAINT OfferingFK FOREIGN KEY (OfferNo) REFERENCES Offering 
                      ON DELETE CASCADE,
    CONSTRAINT StudentFK FOREIGN KEY (StdNo) REFERENCES Student 
                      ON DELETE CASCADE
);

INSERT INTO Faculty VALUES ('543210987','VICTORIA','EMMANUEL','BOTHELL','WA','MS','PROF',120000.0,NULL,'15/Apr/1998','98011-2242');

INSERT INTO Faculty VALUES ('654321098','LEONARD','FIBON','SEATTLE','WA','MS','ASSC',70000.00,'543210987','1/May/1996','98121-0094');

INSERT INTO Faculty VALUES ('098765432','LEONARD','VINCE','SEATTLE','WA','MS','ASST',35000.00,'654321098','10/Apr/1997','98111-9921');

INSERT INTO Faculty VALUES ('765432109','NICKI','MACON','BELLEVUE','WA','FIN','PROF',65000.00,NULL,'11/Apr/1999','98015-9945');

INSERT INTO Faculty VALUES ('876543210','CRISTOPHER','COLAN','SEATTLE','WA','MS','ASST',40000.00,'654321098','1/Mar/2001','98114-1332');

INSERT INTO Faculty VALUES ('987654321','JULIA','MILLS','SEATTLE','WA','FIN','ASSC',75000.00,'765432109','15/Mar/2002','98114-9954');

INSERT INTO Course VALUES ('FIN300','FUNDAMENTALS OF FINANCE',4);

INSERT INTO Course VALUES ('FIN450','PRINCIPLES OF INVESTMENTS',4);

INSERT INTO Course VALUES ('FIN480','CORPORATE FINANCE',4);

INSERT INTO Course VALUES ('IS320','FUNDAMENTALS OF BUSINESS PROGRAMMING',4);

INSERT INTO Course VALUES ('IS460','SYSTEMS ANALYSIS',4);

INSERT INTO Course VALUES ('IS470','BUSINESS DATA COMMUNICATIONS',4);

INSERT INTO Course VALUES ('IS480','FUNDAMENTALS OF DATABASE MANAGEMENT',4);

INSERT INTO Offering VALUES (1111,'IS320','SUMMER',2010,'BLM302','10:30:00',NULL,'MW');

INSERT INTO Offering VALUES (1234,'IS320','FALL',2009,'BLM302','10:30:00','098765432','MW');

INSERT INTO Offering VALUES (2222,'IS460','SUMMER',2009,'BLM412','13:30:00',NULL,'TTH');

INSERT INTO Offering VALUES (3333,'IS320','SPRING',2010,'BLM214','8:30:00','098765432','MW');

INSERT INTO Offering VALUES (4321,'IS320','FALL',2009,'BLM214','15:30:00','098765432','TTH');

INSERT INTO Offering VALUES (4444,'IS320','WINTER',2010,'BLM302','15:30:00','543210987','TTH');

INSERT INTO Offering VALUES (5555,'FIN300','WINTER',2010,'BLM207','8:30:00','765432109','MW');

INSERT INTO Offering VALUES (5678,'IS480','WINTER',2010,'BLM302','10:30:00','987654321','MW');

INSERT INTO Offering VALUES (5679,'IS480','SPRING',2010,'BLM412','15:30:00','876543210','TTH');

INSERT INTO Offering VALUES (6666,'FIN450','WINTER',2010,'BLM212','10:30:00','987654321','TTH');

INSERT INTO Offering VALUES (7777,'FIN480','SPRING',2010,'BLM305','13:30:00','765432109','MW');

INSERT INTO Offering VALUES (8888,'IS320','SUMMER',2010,'BLM405','13:30:00','654321098','MW');

INSERT INTO Offering VALUES (9876,'IS460','SPRING',2010,'BLM307','13:30:00','654321098','TTH');

INSERT INTO Student VALUES ('123456789','HOMER','WELLS','SEATTLE','WA','98121-1111','IS','FR',3.00);

INSERT INTO Student VALUES ('124567890','BOB','NORBERT','BOTHELL','WA','98011-2121','FIN','JR',2.70);

INSERT INTO Student VALUES ('234567890','CANDY','KENDALL','TACOMA','WA','99042-3321','ACCT','JR',3.50);

INSERT INTO Student VALUES ('345678901','WALLY','KENDALL','SEATTLE','WA','98123-1141','IS','SR',2.80);

INSERT INTO Student VALUES ('456789012','JOE','ESTRADA','SEATTLE','WA','98121-2333','FIN','SR',3.20);

INSERT INTO Student VALUES ('567890123','MARIAH','DODGE','SEATTLE','WA','98114-0021','IS','JR',3.60);

INSERT INTO Student VALUES ('678901234','TESS','DODGE','REDMOND','WA','98116-2344','ACCT','SO',3.30);

INSERT INTO Student VALUES ('789012345','ROBERTO','MORALES','SEATTLE','WA','98121-2212','FIN','JR',2.50);

INSERT INTO Student VALUES ('876543210','CRISTOPHER','COLAN','SEATTLE','WA','98114-1332','IS','SR',4.00);

INSERT INTO Student VALUES ('890123456','LUKE','BRAZZI','SEATTLE','WA','98116-0021','IS','SR',2.20);

INSERT INTO Student VALUES ('901234567','WILLIAM','PILGRIM','BOTHELL','WA','98113-1885','IS','SO',3.80);

INSERT INTO Enrollment VALUES (1234,'123456789',3.30);

INSERT INTO Enrollment VALUES (1234,'234567890',3.50);

INSERT INTO Enrollment VALUES (1234,'345678901',3.20);

INSERT INTO Enrollment VALUES (1234,'456789012',3.10);

INSERT INTO Enrollment VALUES (1234,'567890123',3.80);

INSERT INTO Enrollment VALUES (1234,'678901234',3.40);

INSERT INTO Enrollment VALUES (4321,'123456789',3.50);

INSERT INTO Enrollment VALUES (4321,'124567890',3.20);

INSERT INTO Enrollment VALUES (4321,'789012345',3.50);

INSERT INTO Enrollment VALUES (4321,'876543210',3.10);

INSERT INTO Enrollment VALUES (4321,'890123456',3.40);

INSERT INTO Enrollment VALUES (4321,'901234567',3.10);

INSERT INTO Enrollment VALUES (5555,'123456789',3.20);

INSERT INTO Enrollment VALUES (5555,'124567890',2.70);

INSERT INTO Enrollment VALUES (5678,'123456789',3.20);

INSERT INTO Enrollment VALUES (5678,'234567890',2.80);

INSERT INTO Enrollment VALUES (5678,'345678901',3.30);

INSERT INTO Enrollment VALUES (5678,'456789012',3.40);

INSERT INTO Enrollment VALUES (5678,'567890123',2.60);

INSERT INTO Enrollment VALUES (5679,'123456789',2.00);

INSERT INTO Enrollment VALUES (5679,'124567890',3.70);

INSERT INTO Enrollment VALUES (5679,'678901234',3.30);

INSERT INTO Enrollment VALUES (5679,'789012345',3.80);

INSERT INTO Enrollment VALUES (5679,'890123456',2.90);

INSERT INTO Enrollment VALUES (5679,'901234567',3.10);

INSERT INTO Enrollment VALUES (6666,'234567890',3.10);

INSERT INTO Enrollment VALUES (6666,'567890123',3.60);

INSERT INTO Enrollment VALUES (7777,'876543210',3.40);

INSERT INTO Enrollment VALUES (7777,'890123456',3.70);

INSERT INTO Enrollment VALUES (7777,'901234567',3.40);

INSERT INTO Enrollment VALUES (9876,'124567890',3.50);

INSERT INTO Enrollment VALUES (9876,'234567890',3.20);

INSERT INTO Enrollment VALUES (9876,'345678901',3.20);

INSERT INTO Enrollment VALUES (9876,'456789012',3.40);

INSERT INTO Enrollment VALUES (9876,'567890123',2.60);

INSERT INTO Enrollment VALUES (9876,'678901234',3.30);

INSERT INTO Enrollment VALUES (9876,'901234567',4.00);

转换后的代码(到 MY SQL):

CREATE TABLE Faculty ( 
    FacNo         CHAR(11)      NOT NULL, 
    FacFirstName  VARCHAR(30)   NOT NULL, 
    FacLastName   VARCHAR(30)   NOT NULL, 
    FacCity       VARCHAR(30)   NOT NULL, 
    FacState      CHAR(2)       NOT NULL, 
    FacDept       CHAR(6)       NULL, 
    FacRank       CHAR(4)       NULL, 
    FacSalary     DECIMAL(10,2) NULL, 
    FacSupervisor CHAR(11)      NULL, 
    FacHireDate   DATE      NULL, 
    FacZipCode    CHAR(10)      NOT NULL, 
    CONSTRAINT FacultyPK PRIMARY KEY (FacNo),  
    CONSTRAINT SupervisorFK FOREIGN KEY (FacSupervisor) REFERENCES Faculty
);

CREATE TABLE Course ( 
    CourseNo      CHAR(6)       NOT NULL, 
    CrsDesc       VARCHAR(50)   NOT NULL, 
    CrsUnits      INTEGER       NULL, 
    CONSTRAINT CoursePK PRIMARY KEY (CourseNo) 
);

CREATE TABLE Offering ( 
    OfferNo       INTEGER       NOT NULL, 
    CourseNo      CHAR(6)       NOT NULL, 
    OffTerm       CHAR(6)       NOT NULL, 
    OffYear       INTEGER       NOT NULL, 
    OffLocation   VARCHAR(30)   NULL, 
    OffTime       VARCHAR(10)   NULL, 
    FacNo         CHAR(11)      NULL, 
    OffDays       CHAR(4)       NULL, 
    CONSTRAINT OfferingPK PRIMARY KEY (OfferNo), 
    CONSTRAINT CourseFK FOREIGN KEY (CourseNo) REFERENCES Course, 
    CONSTRAINT FacultyFK FOREIGN KEY (FacNo) REFERENCES Faculty
);

CREATE TABLE Student ( 
    StdNo         CHAR(11)      NOT NULL, 
    StdFirstName  VARCHAR(30)   NOT NULL, 
    StdLastName   VARCHAR(30)   NOT NULL, 
    StdCity       VARCHAR(30)   NOT NULL, 
    StdState      CHAR(2)       NOT NULL, 
    StdZip        CHAR(10)      NOT NULL, 
    StdMajor      CHAR(6)       NULL, 
    StdClass      CHAR(2)       NULL, 
    StdGPA        DECIMAL(3,2)  NULL, 
    CONSTRAINT StudentPk PRIMARY KEY (StdNo) 
);

CREATE TABLE Enrollment( 
    OfferNo       INTEGER       NOT NULL, 
    StdNo         CHAR(11)      NOT NULL, 
    EnrGrade      DECIMAL(3,2)  NULL, 
    CONSTRAINT EnrollmentPK PRIMARY KEY (OfferNo,StdNo), 
    CONSTRAINT OfferingFK FOREIGN KEY (OfferNo) REFERENCES Offering 
                      ON DELETE CASCADE,
    CONSTRAINT StudentFK FOREIGN KEY (StdNo) REFERENCES Student 
                      ON DELETE CASCADE
);

INSERT INTO Faculty VALUES ('543210987','VICTORIA','EMMANUEL','BOTHELL','WA','MS','PROF',120000.0,NULL,'15/Apr/1998','98011-2242');

INSERT INTO Faculty VALUES ('654321098','LEONARD','FIBON','SEATTLE','WA','MS','ASSC',70000.00,'543210987','1/May/1996','98121-0094');

INSERT INTO Faculty VALUES ('098765432','LEONARD','VINCE','SEATTLE','WA','MS','ASST',35000.00,'654321098','10/Apr/1997','98111-9921');

INSERT INTO Faculty VALUES ('765432109','NICKI','MACON','BELLEVUE','WA','FIN','PROF',65000.00,NULL,'11/Apr/1999','98015-9945');

INSERT INTO Faculty VALUES ('876543210','CRISTOPHER','COLAN','SEATTLE','WA','MS','ASST',40000.00,'654321098','1/Mar/2001','98114-1332');

INSERT INTO Faculty VALUES ('987654321','JULIA','MILLS','SEATTLE','WA','FIN','ASSC',75000.00,'765432109','15/Mar/2002','98114-9954');

INSERT INTO Course VALUES ('FIN300','FUNDAMENTALS OF FINANCE',4);

INSERT INTO Course VALUES ('FIN450','PRINCIPLES OF INVESTMENTS',4);

INSERT INTO Course VALUES ('FIN480','CORPORATE FINANCE',4);

INSERT INTO Course VALUES ('IS320','FUNDAMENTALS OF BUSINESS PROGRAMMING',4);

INSERT INTO Course VALUES ('IS460','SYSTEMS ANALYSIS',4);

INSERT INTO Course VALUES ('IS470','BUSINESS DATA COMMUNICATIONS',4);

INSERT INTO Course VALUES ('IS480','FUNDAMENTALS OF DATABASE MANAGEMENT',4);

INSERT INTO Offering VALUES (1111,'IS320','SUMMER',2010,'BLM302','10:30:00',NULL,'MW');

INSERT INTO Offering VALUES (1234,'IS320','FALL',2009,'BLM302','10:30:00','098765432','MW');

INSERT INTO Offering VALUES (2222,'IS460','SUMMER',2009,'BLM412','13:30:00',NULL,'TTH');

INSERT INTO Offering VALUES (3333,'IS320','SPRING',2010,'BLM214','8:30:00','098765432','MW');

INSERT INTO Offering VALUES (4321,'IS320','FALL',2009,'BLM214','15:30:00','098765432','TTH');

INSERT INTO Offering VALUES (4444,'IS320','WINTER',2010,'BLM302','15:30:00','543210987','TTH');

INSERT INTO Offering VALUES (5555,'FIN300','WINTER',2010,'BLM207','8:30:00','765432109','MW');

INSERT INTO Offering VALUES (5678,'IS480','WINTER',2010,'BLM302','10:30:00','987654321','MW');

INSERT INTO Offering VALUES (5679,'IS480','SPRING',2010,'BLM412','15:30:00','876543210','TTH');

INSERT INTO Offering VALUES (6666,'FIN450','WINTER',2010,'BLM212','10:30:00','987654321','TTH');

INSERT INTO Offering VALUES (7777,'FIN480','SPRING',2010,'BLM305','13:30:00','765432109','MW');

INSERT INTO Offering VALUES (8888,'IS320','SUMMER',2010,'BLM405','13:30:00','654321098','MW');

INSERT INTO Offering VALUES (9876,'IS460','SPRING',2010,'BLM307','13:30:00','654321098','TTH');

INSERT INTO Student VALUES ('123456789','HOMER','WELLS','SEATTLE','WA','98121-1111','IS','FR',3.00);

INSERT INTO Student VALUES ('124567890','BOB','NORBERT','BOTHELL','WA','98011-2121','FIN','JR',2.70);

INSERT INTO Student VALUES ('234567890','CANDY','KENDALL','TACOMA','WA','99042-3321','ACCT','JR',3.50);

INSERT INTO Student VALUES ('345678901','WALLY','KENDALL','SEATTLE','WA','98123-1141','IS','SR',2.80);

INSERT INTO Student VALUES ('456789012','JOE','ESTRADA','SEATTLE','WA','98121-2333','FIN','SR',3.20);

INSERT INTO Student VALUES ('567890123','MARIAH','DODGE','SEATTLE','WA','98114-0021','IS','JR',3.60);

INSERT INTO Student VALUES ('678901234','TESS','DODGE','REDMOND','WA','98116-2344','ACCT','SO',3.30);

INSERT INTO Student VALUES ('789012345','ROBERTO','MORALES','SEATTLE','WA','98121-2212','FIN','JR',2.50);

INSERT INTO Student VALUES ('876543210','CRISTOPHER','COLAN','SEATTLE','WA','98114-1332','IS','SR',4.00);

INSERT INTO Student VALUES ('890123456','LUKE','BRAZZI','SEATTLE','WA','98116-0021','IS','SR',2.20);

INSERT INTO Student VALUES ('901234567','WILLIAM','PILGRIM','BOTHELL','WA','98113-1885','IS','SO',3.80);

INSERT INTO Enrollment VALUES (1234,'123456789',3.30);

INSERT INTO Enrollment VALUES (1234,'234567890',3.50);

INSERT INTO Enrollment VALUES (1234,'345678901',3.20);

INSERT INTO Enrollment VALUES (1234,'456789012',3.10);

INSERT INTO Enrollment VALUES (1234,'567890123',3.80);

INSERT INTO Enrollment VALUES (1234,'678901234',3.40);

INSERT INTO Enrollment VALUES (4321,'123456789',3.50);

INSERT INTO Enrollment VALUES (4321,'124567890',3.20);

INSERT INTO Enrollment VALUES (4321,'789012345',3.50);

INSERT INTO Enrollment VALUES (4321,'876543210',3.10);

INSERT INTO Enrollment VALUES (4321,'890123456',3.40);

INSERT INTO Enrollment VALUES (4321,'901234567',3.10);

INSERT INTO Enrollment VALUES (5555,'123456789',3.20);

INSERT INTO Enrollment VALUES (5555,'124567890',2.70);

INSERT INTO Enrollment VALUES (5678,'123456789',3.20);

INSERT INTO Enrollment VALUES (5678,'234567890',2.80);

INSERT INTO Enrollment VALUES (5678,'345678901',3.30);

INSERT INTO Enrollment VALUES (5678,'456789012',3.40);

INSERT INTO Enrollment VALUES (5678,'567890123',2.60);

INSERT INTO Enrollment VALUES (5679,'123456789',2.00);

INSERT INTO Enrollment VALUES (5679,'124567890',3.70);

INSERT INTO Enrollment VALUES (5679,'678901234',3.30);

INSERT INTO Enrollment VALUES (5679,'789012345',3.80);

INSERT INTO Enrollment VALUES (5679,'890123456',2.90);

INSERT INTO Enrollment VALUES (5679,'901234567',3.10);

INSERT INTO Enrollment VALUES (6666,'234567890',3.10);

INSERT INTO Enrollment VALUES (6666,'567890123',3.60);

INSERT INTO Enrollment VALUES (7777,'876543210',3.40);

INSERT INTO Enrollment VALUES (7777,'890123456',3.70);

INSERT INTO Enrollment VALUES (7777,'901234567',3.40);

INSERT INTO Enrollment VALUES (9876,'124567890',3.50);

INSERT INTO Enrollment VALUES (9876,'234567890',3.20);

INSERT INTO Enrollment VALUES (9876,'345678901',3.20);

INSERT INTO Enrollment VALUES (9876,'456789012',3.40);

INSERT INTO Enrollment VALUES (9876,'567890123',2.60);

INSERT INTO Enrollment VALUES (9876,'678901234',3.30);

INSERT INTO Enrollment VALUES (9876,'901234567',4.00);

最佳答案

1) 正如 Nick 所回答的，外键语法需要修复。有 5 个外键声明需要更改:

CREATE TABLE Faculty ( 
    ...
    CONSTRAINT SupervisorFK FOREIGN KEY (FacSupervisor) REFERENCES Faculty(FacNo)
);

CREATE TABLE Offering ( 
    ...
    CONSTRAINT CourseFK FOREIGN KEY (CourseNo) REFERENCES Course(CourseNo),
    CONSTRAINT FacultyFK FOREIGN KEY (FacNo) REFERENCES Faculty(FacNo)
);

CREATE TABLE Enrollment( 
    ....
    CONSTRAINT OfferingFK FOREIGN KEY (OfferNo) REFERENCES Offering(OfferNo) 
        ON DELETE CASCADE,
    CONSTRAINT StudentFK FOREIGN KEY (StdNo) REFERENCES Student(StdNo) 
        ON DELETE CASCADE
);

CONSTRAINT CourseFK FOREIGN KEY (CourseNo) REFERENCES Course(CourseNo)

代替:

CONSTRAINT CourseFK FOREIGN KEY (CourseNo) REFERENCES Course

2) 在插入数据时，您应该预料到处理日期时会出现问题。您正在为数据类型 date(即 Faculty.FacHireDate)的列提供 MySQL 值，例如 '1/Mar/2001':它将不接受。日期的默认格式是 yyyy-mm-dd。

一种解决方案是在从 Oracle 提取数据时转换格式，方法是使用 TO_CHAR(FacHireDate, 'yyyy-mm-dd')，或者可能通过更改 NLS parameter NLS_DATE_FORMAT .否则，您可以使用 MySQL function STR_TO_DATE()将字符串翻译成日期:

INSERT INTO Faculty VALUES (
    '543210987',
    'VICTORIA',
    'EMMANUEL',
    'BOTHELL',
    'WA',
    'MS',
    'PROF',
    120000.0,
    NULL,
    STR_TO_DATE('15/Apr/1998', '%d/%b/%Y'),
    '98011-2242'
);

通过这些修复，脚本在 this MySQL DB Fiddle 中运行良好.

关于mysql - Oracle和MySQL的代码形式区别，我们在Stack Overflow上找到一个类似的问题： https://stackoverflow.com/questions/54817992/

文章推荐：具有复合主键和触发器自动增量的 MySQL 死锁

文章推荐： iOS Core Data 乐观锁失败误报

文章推荐： ios - Obj-C - didSelectRowAtIndexPath 未触发？

oracle - Oracle 即时客户端和 Oracle 客户端的区别
Oracle 即时客户端和 Oracle 客户端有什么区别？你能给我解释一下吗？谢谢最佳答案 Oracle 客户端带有安装程序和许多可执行文件，例如 sqlplus，tnsping，它是完整而庞大的
oracle - 无需安装 Oracle 客户端即可连接 ORACLE 数据库服务器的替代方案
我正在寻找一个Delphi组件来直接连接到ORACLE数据库服务器，而无需安装oracle客户端。我知道Oracle Data Access (ODAC)来自DevArt 。还有其他组件具有此功能吗
oracle - 使用 Oracle 表作为输入参数编写 Oracle 存储过程
如何编写 Oracle 存储过程，以表 (X) 作为输入参数，并在过程内部使用表 X 来与另一个表 Y 联接？表 X 将包含数千条记录。不希望将表名作为 varchar 传递，然后使用动态 SQL
oracle - 使用 Oracle 表作为输入参数编写 Oracle 存储过程
如何编写 Oracle 存储过程，以表 (X) 作为输入参数，并在过程内部使用表 X 来与另一个表 Y 联接？表 X 将包含数千条记录。不希望将表名作为 varchar 传递，然后使用动态 SQL
oracle - Oracle sql中如何过滤空值
我要过滤COMMENTS属性为空的记录我试过了 SELECT TABLE_NAME, COMMENTS FROM (SELECT TABLE_NAME, COMMENTS FROM (sel
oracle - Oracle 工具的替代下载站点
我要下载 Oracle Instant Client for Linux x86-64 (64-bit)现在有一段时间了。现在我注意到该网站在过去几个月中一直遇到技术问题。要从 Oracle 下载
oracle - 没有安装 Oracle 客户端的 Delphi FireDac + Oracle
有什么方法可以将我的 Delphi 应用程序 (FireDac) 直接连接到 Oracle 数据库？目前可以连接，但需要安装Oracle Client 在 embarcadero 站点 ( http
oracle - where子句中的日期格式-Oracle
我有一张表，其中日期列的数据格式如下:“7/25/2014 12:14:27 AM”。我需要通过放入 where 子句来获取此日期。有人可以建议我该怎么做吗？最佳答案日期(存储在表中)是 repr
oracle - Oracle 中两个事务可以同时修改同一行吗？
如果两个事务试图同时修改同一行会发生什么？通常，一旦行被修改，另一个事务等待直到第一个事务执行提交或回滚。但是，如果他们恰好在同一时刻发送更新请求怎么办？最佳答案答案是否定的。两个事务不能同时修改
oracle - Oracle 模式中具有相同名称的两个索引
我想知道为什么我不能在 Oracle 模式中有两个同名的索引？它抛出一个错误，指出该名称已被使用。我的印象是，由于索引在一个特定的表上，这应该不会导致任何错误，除非我们对同一个表上的两个不同列使用相同
oracle - Oracle sql中的rownum与group by
我需要构建一个查询来按成员和到期日期检索信息组，但我需要为每个成员提供一个序列号.. 例如: 如果成员“A”有 3 条记录要过期，“B”只有 1 条，“C”有 2 条，我需要这样的结果: Number
oracle - Oracle 中的存储过程和独立过程有什么区别？
独立程序 create procedure proc1 ( begin end; ) 存储过程 create package pkg1 ( procedure proc2 begin end; ) 最
oracle - Oracle 中的外键约束问题
在 Oracle 9i 中声明 FK 时遇到问题。我在这里查看了许多关于 SO 和一些在线文档(例如 http://www.techonthenet.com/oracle/foreign_keys/f
oracle - Oracle 序列存储在哪个表空间中？
我和我的同事维护的应用程序在后端有一个 Oracle 数据库。我们正在考虑偶尔以“受限”模式运行应用程序，其中一个数据库表空间设置为只读。我们可以轻松地将必要的表和索引移动到单独的表空间，这些表空间将
oracle - Oracle 的用户定义聚合函数可以定义为用于两列吗？
我想实现一个自定义的回归聚合函数，类似于现有的 REGR_SLOPE . 我要定义的函数需要获取两列作为参数，例如 select T.EMPLOYEE_ID, CUSTOM_REGR_SL
oracle - Oracle 脚本中的错误处理
我已经尝试解决这个问题一段时间了，我认为是时候寻求帮助了。我正在构建一个架构配置脚本，我想添加一些脚本输出和错误处理。这个想法是脚本输出窗口只会向我显示关键消息而没有所有噪音。 Create Temp
oracle - Oracle 批量更新速度慢
在旧的 Oracle 服务器(我被告知是 8i)上使用 JDBC 时，我遇到了一个非常令人困惑和奇怪的问题。我在那里准备了一个表，其中包含大约 10 列、数字、varchars、一个 raw(255)
oracle - Oracle 分区表的唯一索引
我有一张 table Customer_Chronics在 Oracle 11g 中。该表具有三个关键列，如下所示: 分支代码客户 ID 期我已按 branch_code 列表按表分区，现在我进
oracle - oracle 在哪里存储用户定义的异常？
是否有存储用户自定义异常的oracle表？最佳答案没有。与其他变量一样，用户定义的异常在 PL/SQL block 中定义，并且具有 PL/SQL 变量将具有的任何范围。所以，例如 DECLAR
oracle - Oracle 中的序列与标识列
在 oracle 中使用序列并使用 Before insert trigger 自动递增列或使用标识列是否更好，因为它在 Oracle 12 c 中可用？最佳答案无论哪种方式，您都将使用序列。 1

行者123

个人简介

我是一名优秀的程序员,十分优秀！

作者热门文章

滴滴打车优惠券免费领取

全站热门文章

首页

博学

6Ren·AI

商城

mysql - Oracle和MySQL的代码形式区别