如何使用oracle SQL开发人员的对象 - 关系数据库功能在表之间定义对象引用 [英] How do I define object-references between tables using the object-relational database feature of oracle SQL developer
问题描述
我在Oracle 11g中成功创建了一个带有以下属性的EmployeeType;
emp_id VARCHAR2(5)
title VARCHAR(15)
名字VARCHAR(20)
姓氏VARCHAR(20)
地址地址类型
tel_no ARRAY(3)of VARCHAR(15)
get_address()VARCHAR2()
并被告知在Oracle 11g中使用以下属性创建DepartmentType
dept_id VARCHAR2(3)
位置地址类型
经理REF员工
但我现在的问题是我不知道如何使用对象关系REF构造来定义两个表之间的对象引用,以便将Departments与Employees相关联,这样我就可以创建存储部门细节的表并插入行。
I successfully created an EmployeeType in Oracle 11g with the following atrributes;
emp_id VARCHAR2(5)
title VARCHAR(15)
firstname VARCHAR(20)
surname VARCHAR(20)
address Addresstype
tel_no ARRAY(3) of VARCHAR(15)
get_address() VARCHAR2()
and was told to create DepartmentType in Oracle 11g with the following attributes
dept_id VARCHAR2(3)
location AddressType
manager REF Employee
but my problem now is I don''t know how to use the object-relational REF construct to define object-references between the two tables for relating Departments to Employees so that I can create table which will store department details and insert rows.
推荐答案
您好,
您需要在子表中创建外键(员工) )使用父表(部门)。
查看以下链接...
SQL FOREIGN KEY约束 [ ^ ]
Oracle / PLSQL:外键 [ ^ ]
使用外键创建表 [ ^ ]
问候,
GVPrabu
Hi,
You need to create Foreign Key in Child Table (Employee) using Parent Table (Department).
Check the following Links...
SQL FOREIGN KEY Constraint[^]
Oracle/PLSQL: Foreign Keys[^]
Create table with foreign key[^]
Regards,
GVPrabu
hai朋友,
hai friend,
create table emp
(emp_id VARCHAR2(5),
title VARCHAR(15),
firstname VARCHAR(20),
surname VARCHAR(20),
dept_id number,
CONSTRAINT emp_dept_fk FOREIGN KEY (dept_id)
REFERENCES dept(dept_id))
create table dept
(dept_id number primary key,
dept_name varchar2(50))
语法
syntax
CONSTRAINT CONSTRAINT_NAME FOREIGN KEY (CHILDTABLE COLUMN)
REFERENCES PARAENTTABLE_NAME(PARAENTTABLE COLUMN))
这篇关于如何使用oracle SQL开发人员的对象 - 关系数据库功能在表之间定义对象引用的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!