建表EMP 并设MEPID为主键
create table emp
(empid varchar2(10),
empname varchar2(10),
empadd varchar2(20),
empphone varchar2(12),
email varchar2(20),
mgr varchar2(6),
hiredate date,
comm number(7,2),
deptno number(2),
constraint emp_pk primary key(empid));
创建表DEPART 并创建外键EMPID 参照表EMPID
create table depart
(deptno number(2),
empid varchar2(10),
depname varchar2(10),
pro varchar2(12),
sal varchar2(6),
educa varchar2(12),
exper varchar2(20),
loc varchar2(13),
constraint depart_empid_fk
foreign key(empid) references emp(empid));
查询外键名称
select constraint_name constraint_type,search_condition
from user_constraints
where table_name = 'depart';
各们兄弟,新手学习中不知道为什么查询总是说, no rows selected
在资料上在看的,会显示 constraint_name
search_condition
depart_empid_fk 为什么我的显示是没有行选择.

最新回复
yzsind (2008-9-01 08:58:44)
table_name = 'DEPART';