📄 oracle pl-sql学习笔记.htm
字号:
statements, VALUE_ERROR is raised if the
conversion of a <BR>character string into a
number fails. (In SQL statements, INVALID_NUMBER
is raised.) </P>
<P>ZERO_DIVIDE <BR>Your program attempts to
divide a number by zero. </P>
<P><BR>3 连接查询
<BR>----------------------------------------
<BR>假设两个表s1cardinf,s1prefer <BR>s1cardinf内容:
<BR>allindex <BR>1 <BR>2 <BR>3 </P>
<P>s1prefer内容: <BR>allindex <BR>2 <BR>3 <BR>4
</P>
<P>select a.allindex,b.allindex <BR>from
s1cardinf a , s1prefer b <BR>where a.allindex =
b.allindex ; <BR>结果: <BR>allindex,allindex <BR>2
2 <BR>3 3 </P>
<P>select a.allindex,b.allindex <BR>from
s1cardinf a , s1prefer b <BR>where a.allindex
(+) = b.allindex ; <BR>结果: <BR>allindex,allindex
<BR>2 2 <BR>3 3 <BR>null 4 </P>
<P>select a.allindex,b.allindex <BR>from
s1cardinf a , s1prefer b <BR>where a.allindex =
b.allindex (+) ; <BR>结果: <BR>allindex,allindex
<BR>1 null <BR>2 2 <BR>3 3
</P></TD></TR></TBODY></TABLE>
<SCRIPT language=javascript
src="Oracle PL-SQL学习笔记_files/15.js"></SCRIPT>
</TD></TR>
<TR>
<TD>
<SCRIPT language=javascript
src="Oracle PL-SQL学习笔记_files/6.js"></SCRIPT>
</TD></TR></TBODY></TABLE></TD>
<TR>
<TD align=middle height=20></TD></TR></TBODY></TABLE></TD>
<TD width=14></TD></TR></TBODY></TABLE></TD></TR><!-- 文章部分结束 -->
<TR>
<TD align=middle
background="Oracle PL-SQL学习笔记_files/top_menu_bg.gif">
<TABLE cellSpacing=0 cellPadding=0 width="100%" border=0>
<TBODY>
<TR vAlign=center>
<TD width=6
background="Oracle PL-SQL学习笔记_files/top_menu_bg.gif"></TD>
<TD class=main_page align=right width=565
height=75>数据库录入：admin 责任编辑：admin <FONT
color=#009999>★★★</FONT> <!-- 文章页面代码 --></TD>
<TD width=8></TD></TR></TBODY></TABLE></TD></TR><!-- 文章图片部分开始 -->
<TR>
<TD align=middle
background="Oracle PL-SQL学习笔记_files/top_menu_bg.gif">
<TABLE cellSpacing=0 cellPadding=0 width="100%" border=0>
<TBODY>
<TR vAlign=center>
<TD width=10
background="Oracle PL-SQL学习笔记_files/top_menu_bg.gif"></TD>
<TD align=middle width=778 height=75>
<TABLE cellSpacing=5 cellPadding=0 width="100%"
align=center border=0>
<TBODY>
<TR vAlign=top>
<TD align=middle><A
title="数据库标题：Oracle PL/SQL的第一次接触 作 者：未知 更新时间：2006-2-7 19:15:13"
href="http://www.adminnet.cn/sql/Oracle/PLSQL/200602/5686.html"
target=_blank><IMG class=pic1 height=60
src="Oracle PL-SQL学习笔记_files/20060207191534767.jpg"
width=85 border=0><BR>Oracle PL/…</A></TD>
<TD align=middle><A
title="数据库标题：SQL Server 2005与DB2 8.2之对比 作 者：佚名 更新时间：2006-1-22 22:37:03"
href="http://www.adminnet.cn/sql/SQLServer/200601/5557.html"
target=_blank><IMG class=pic1 height=60
src="Oracle PL-SQL学习笔记_files/20060122223753781.gif"
width=85 border=0><BR>SQL Server…</A></TD>
<TD align=middle><A
title="数据库标题：Oracle10g RAC with ocfs在windows安装 作 者：未知 更新时间：2006-1-3 14:24:14"
href="http://www.adminnet.cn/sql/Oracle/Oraclejid/200601/5251.html"
target=_blank><IMG class=pic1 height=60
src="Oracle PL-SQL学习笔记_files/20060103142550443.jpg"
width=85 border=0><BR>Oracle10g …</A></TD>
<TD align=middle><A
title="数据库标题：用SQL Server 2005索引视图提高性能一 作 者：佚名 更新时间：2005-12-1 18:57:48"
href="http://www.adminnet.cn/sql/SQLServer/200512/4426.html"
target=_blank><IMG class=pic1 height=60
src="Oracle PL-SQL学习笔记_files/20051201185808320.gif"
width=85 border=0><BR>用SQL Serv…</A></TD>
<TD align=middle><A
title="数据库标题：SQL Server 2005 安全性 作 者：佚名 更新时间：2005-12-1 18:55:49"
href="http://www.adminnet.cn/sql/SQLServer/200512/4424.html"
target=_blank><IMG class=pic1 height=60
src="Oracle PL-SQL学习笔记_files/20051201185649318.jpg"
width=85 border=0><BR>SQL Server…</A></TD>
<TD align=middle><A
title="数据库标题：SQL Server 2005：向系统表说再见 作 者：佚名 更新时间：2005-12-1 18:51:33"
href="http://www.adminnet.cn/sql/SQLServer/200512/4421.html"
target=_blank><IMG class=pic1 height=60
src="Oracle PL-SQL学习笔记_files/20051201185343885.jpg"
width=85
border=0><BR>SQL Server…</A></TD></TR></TBODY></TABLE><!-- 文章图片代码 --></TD>
<TD width=14></TD></TR></TBODY></TABLE></TD></TR><!-- 文章图片部分结束 --><!-- 文章底部开始 -->
<TR>
<TD align=middle
background="Oracle PL-SQL学习笔记_files/top_menu_bg.gif">
<TABLE cellSpacing=0 cellPadding=0 width="100%" border=0>
<TBODY>
<TR vAlign=center>
<TD width=6
background="Oracle PL-SQL学习笔记_files/top_menu_bg.gif"></TD>
<TD class=main_page align=right width=618 height=75><A
title=收藏的网页将被永久地保存到爱问ViVi收藏夹http://vivi.sina.com.cn
href="javascript:d=document;t=d.selection?(d.selection.type!='None'?d.selection.createRange().text:''):(d.getSelection?d.getSelection():'');void(vivi=window.open('http://vivi.sina.com.cn/collect/icollect.php?pid=http://www.chinaccna.com&title='+escape(d.title)+'&url='+escape(d.location.href)+'&desc='+escape(t),'vivi','scrollbars=no,width=480,height=480,left=75,top=20,status=no,resizable=yes'));vivi.focus();"><IMG
src="Oracle PL-SQL学习笔记_files/vivi_coop.gif"
border=0></A>【字体：<A class=top_UserLogin
href="javascript:fontZoomA();">小</A> <A
class=top_UserLogin
href="javascript:fontZoomB();">大</A>】 【<A
href="http://www.adminnet.cn/sql/Comment.asp?ArticleID=5687"
target=_blank>发表评论</A>】【<A
href="http://www.adminnet.cn/User/User_Favorite.asp?Action=Add&ChannelID=1013&InfoID=5687"
target=_blank>加入收藏</A>】【<A
href="http://www.adminnet.cn/sql/SendMail.asp?ArticleID=5687"
target=_blank>告诉好友</A>】【<A
href="http://www.adminnet.cn/sql/Print.asp?ArticleID=5687"
target=_blank>打印此文</A>】【<A
href="javascript:window.close();">关闭窗口</A>】 <!-- 文章页面代码 --></TD>
<TD width=8></TD></TR></TBODY></TABLE></TD></TR>
<TR>
<TD align=middle
background="Oracle PL-SQL学习笔记_files/top_menu_bg.gif">
<TABLE cellSpacing=0 cellPadding=0 width="100%" border=0>
<TBODY>
<TR vAlign=center>
<TD width=6
background="Oracle PL-SQL学习笔记_files/top_menu_bg.gif"></TD>
<TD align=left width=618>
<LI>上一个数据库： <A class=LinkPrevArticle
title="数据库标题：Oracle PL/SQL的第一次接触 作 者：未知 更新时间：2006-2-7 19:15:13"
href="http://www.adminnet.cn/sql/Oracle/PLSQL/200602/5686.html">Oracle PL/SQL的第一次接触</A><BR>
<LI>下一个数据库： 没有了 <!-- 文章页面代码 --></LI></TD>
<TD width=8></TD></TR></TBODY></TABLE></TD></TR>
<TR>
<TD align=middle
background="Oracle PL-SQL学习笔记_files/top_menu_bg.gif">
<TABLE cellSpacing=0 cellPadding=0 width="100%" border=0>
<TBODY>
<TR vAlign=center>
<TD width=6
background="Oracle PL-SQL学习笔记_files/top_menu_bg.gif"></TD>
<TD align=middle width=618><IMG height=60
src="Oracle PL-SQL学习笔记_files/20050418162012510.jpg"
width=618> </TD>
<TD width=8></TD></TR></TBODY></TABLE></TD></TR><!-- 文章底部结束 --><!-- 评论部分开始 -->
<TR>
<TD align=middle
background="Oracle PL-SQL学习笔记_files/top_menu_bg.gif">
<TABLE cellSpacing=0 cellPadding=0 width="100%" border=0>
<TBODY>
<TR>
<TD align=left width=6
background="Oracle PL-SQL学习笔记_files/top_menu_bg.gif">
<TD align=left width=570
background="Oracle PL-SQL学习笔记_files/title_bg.gif">
<TABLE cellSpacing=0 cellPadding=0 width="100%"
border=0>
<TBODY>
<TR>
<TD vAlign=bottom align=middle width=228
background="Oracle PL-SQL学习笔记_files/title.gif"
height=24><FONT color=#78733c><A class=class
href="http://www.adminnet.cn/sql/Comment.asp?ArticleID=5687"
target=_blank><FONT
color=#78733c>发表评论</FONT></A></FONT></TD>
<TD width=337
background="Oracle PL-SQL学习笔记_files/title_bg.gif"
height=24></TD></TR></TBODY></TABLE></TD>
<TD align=middle width=8></TD></TR></TBODY></TABLE></TD></TR>
<TR>
<TD align=middle
background="Oracle PL-SQL学习笔记_files/top_menu_bg.gif">
<TABLE cellSpacing=0 cellPadding=0 width="100%" border=0>
<TBODY>
<TR>
<TD align=left width=6
background="Oracle PL-SQL学习笔记_files/top_menu_bg.gif">
<TD align=left width=618 height=60>
<SCRIPT language=javascript
src="Oracle PL-SQL学习笔记_files/Comment.htm"></SCRIPT>
</TD>
<TD align=left width=8></TD></TR></TBODY></TABLE></TD></TR><!-- 评论部分结束 --></TR></TBODY></TABLE></TD></TR></TBODY></TABLE>
<TABLE height=5 cellSpacing=0 cellPadding=0 width=778 bgColor=#000000
border=0>
<TBODY>
<TR>
<TD></TD></TR></TBODY></TABLE>
<TABLE cellSpacing=0 cellPadding=0 width=778 border=0>
<TBODY>
<TR>
<TD>
<SCRIPT language=javascript
src="Oracle PL-SQL学习笔记_files/bottom.js"></SCRIPT>
</TD></TR></TBODY></TABLE><!-- Powered by: PowerEasy 2005 --></TR></TBODY></TABLE></BODY></HTML>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -