首页数据库 Oracle Oracle笔记七、PL/SQL 异常处理

Oracle笔记七、PL/SQL 异常处理

dawei 2020年12月30日 8:30

–异常处理declaresNum number := 0;beginsNum := 5 / sNum;dbms_output.put_line(sNum);exceptionwhen others thendbms_output.put_line(is Error!);end;–自定义异常declareex_custom_invaild_age exception; –自定义的异常myerrage int;beginage := 请输

<div id=”codeSnippetWrapper”> <div style=”border-bottom-style: none; text-align: left; padding-bottom: 0px; line-height: 12pt; border-right-style: none; background-color: #f4f4f4; padding-left: 0px; width: 100%; padding-right: 0px; font-family: ‘Courier New’,courier,monospace; direction: ltr; border-top-style: none; color: black; font-size: 10pt; border-left-style: none; overflow: visible; padding-top: 0px” id=”codeSnippet”>
<pre style=”border-bottom-style: none; text-align: left; padding-bottom: 0px; line-height: 12pt; border-right-style: none; background-color: white; margin: 0em; padding-left: 0px; width: 100%; padding-right: 0px; font-family: ‘Courier New’,monospace; direction: ltr; border-top-style: none; color: black; font-size: 10pt; border-left-style: none; overflow: visible; padding-top: 0px”>–异常处理