📄 219.html
字号:
<STYLE type=text/css>
<!--
body,td { font-size:9pt;}
hr { color: #000000; height: 1px}
-->
</STYLE>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" "http://www.w3.org/TR/REC-html40/loose.dtd">
<HTML>
<HEAD><TITLE>FAQ汇萃 >> Oracle 专栏 >> 如何查询出primary key和forgen key的关系表？</title>
</head>
<body >
<p><IMG SRC="../image/jsp001_middle_logo.gif" WIDTH="180" HEIGHT="60" BORDER=0 ALT=""></p>
<table width=100% bgcolor="#cccccc" align=center cellpadding="2" cellspacing="0" border=1 bordercolorlight="#000000" bordercolordark="#FFFFFF">
<tr bgcolor="#EFF8FF"><td>
<a href=../list_thread.php?int_attribute=1>FAQ汇萃</a>
>> <a href=../list_thread.php?forumid=20&int_attribute=1>Oracle 专栏</a>
>> 如何查询出primary key和forgen key的关系表？ [<a href=../forum/showthread.php?goto=newpost&threadid=219>查看别人的评论</a>]<br>
<hr><p>由 webmaster 发布于: 2001-02-03 13:41</p><p><img src="images/icons/icon12.gif" alt="Wink" border=0> </p><p>SQL> create user a identified by a; --创建测试用户a
<br>SQL> grant connect,resource to a; --给用户a授权
<br>SQL> conn a/a --以用户a连接
<br>
<br>SQL> create table a1(a11 number primary key);
<br>SQL> insert into a1 values(1);
<br>SQL> insert into a1 values(2);
<br>SQL> insert into a1 values(3);
<br>SQL> commit;
<br>
<br>SQL> create table b1
<br> 2 (
<br> 3 b11 char(1),
<br> 4 b12 number,
<br> 5 foreign key(b12) references a1(a11)
<br> 6 )
<br> 7 /
<br>
<br>SQL> insert into b1 values('a',4);
<br>insert into b1 values('a',4)
<br>*
<br>ERROR 位于第 1 行:
<br>ORA-02291: 违反完整约束条件 (A.SYS_C001241) - 未找到父项关键字
<br>
<br>注：a1表中a11列上只有1、2、3这三个值，而b1表中的列b12定义时引用了a1表中的a11列，
<br>那么，在向b1表中录入记录时，b12列只能录1、2、3，而不能输入4。
<br>
<br>SQL> create table a2(a21 number primary key);
<br>SQL> insert into a2 values(1);
<br>SQL> insert into a2 values(2);
<br>SQL> insert into a2 values(3);
<br>SQL> commit;
<br>
<br>SQL> create table b2
<br> 2 (
<br> 3 b21 char(1),
<br> 4 b22 number,
<br> 5 foreign key(b22) references a2(a21)
<br> 6 )
<br> 7 /
<br>
<br>注：以下语句查询primary key和forgen key的关系表
<br>
<br>SQL> col 外键拥有者 format a10
<br>SQL> col 外键表 format a10
<br>SQL> col 主键拥有者 format a10
<br>SQL> col 主键表 format a10
<br>SQL> col 外键列 format a15
<br>SQL> col 主键列 format a15
<br>
<br>select
<br>a.owner 外键拥有者,
<br>a.table_name 外键表,
<br>c.column_name 外键列,
<br>b.owner 主键拥有者,
<br>b.table_name 主键表,
<br>d.column_name 主键列
<br>from
<br>user_constraints a,
<br>user_constraints b,
<br>user_cons_columns c,
<br>user_cons_columns d
<br>where
<br> a.r_constraint_name=b.constraint_name
<br>and a.constraint_type='R'
<br>and b.constraint_type='P'
<br>and a.r_owner=b.owner
<br>and a.constraint_name=c.constraint_name
<br>and b.constraint_name=d.constraint_name
<br>and a.owner=c.owner
<br>and a.table_name=c.table_name
<br>and b.owner=d.owner
<br>and b.table_name=d.table_name
<br>/
<br>
<br>
<br>外键拥有者 外键表 外键列 主键拥有者 主键表 主键列
<br>---------- ---------- --------------- ---------- ---------- ------
<br>A B1 B12 A A1 A11
<br>A B2 B22 A A2 A21
<br></p></td>
</tr>
</table>
<p>
<CENTER><a href="../forum/newreply.php?action=newreply&threadid=219">点这里对该文章发表评论</a></CENTER>
<p>该文章总得分是 <font color=red>0</font> 分，你认为它对你有帮助吗？
[<a href=javascript:void(0) onclick=window.open("../forum/codeVote.php?threadid=219&intVote=4","","menubar=no,toolbar=no,location=no,directories=no,status=no,resizable=no,scrollbars=no,width=70,height=40,top=0,left=0")>非常多</a>](<font color=red>0</font>)
[<a href=javascript:void(0) onclick=window.open("../forum/codeVote.php?threadid=219&intVote=2","","menubar=no,toolbar=no,location=no,directories=no,status=no,resizable=no,scrollbars=no,width=70,height=40,top=0,left=0")>有一些</a>](<font color=red>0</font>)
[<a href=javascript:void(0) onclick=window.open("../forum/codeVote.php?threadid=219&intVote=1","","menubar=no,toolbar=no,location=no,directories=no,status=no,resizable=no,scrollbars=no,width=70,height=40,top=0,left=0")>无帮助</a>](<font color=red>0</font>)
[<a href=javascript:void(0) onclick=window.open("../forum/codeVote.php?threadid=219&intVote=-1","","menubar=no,toolbar=no,location=no,directories=no,status=no,resizable=no,scrollbars=no,width=70,height=40,top=0,left=0")>是灌水</a>](<font color=red>0</font>) </p>
<script language="javascript" src="../include/read_thread_script.php?threadid=219"></script>
<p><CENTER>
Copyright © 2001 - 2009 JSP001.com . All Rights Reserved <P>
<IMG SRC="../image/jsp001_small_logo.gif" WIDTH="85" HEIGHT="30" BORDER=0 ALT="">
</CENTER></p>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -