?? 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 + -