set serveroutput on
declare
a number(5);
b number(5);
c number(5);
begin
a:=&a;
b:=&b;
c:=a/b;
dbms_output.put_line(c);
exception
when zero_divide then
dbms_output.put_line(''there is a divide by zero error'');
end;
/

Posted Date: 3/18/2015 1:10:18 AM | Location : USA

Ask an Expert

Related Discussions:- exception handling, Assignment Help, Ask Question on exception handling, Get Answer, Expert's Help, exception handling Discussions

Write discussion on exception handling
Your posts are moderated

Write your message here..

Related Questions

Create a sql database, The requirements as follows: Create a folder call... The requirements as follows: Create a folder called "SECURITY" on the server and upload all your project files to that folder. Please note, the "SECURITY" folder is NOT to be IN

Using subqueries, Using Subqueries A subquery is a query (typically ... Using Subqueries A subquery is a query (typically enclosed by parentheses) that appears within another SQL data manipulation statement. If evaluated, the subquery gives a va

Write an anonymous block that contains a pl/sql procedure, Write an anonymo... Write an anonymous block that contains a PL/SQL procedure. The procedure takes two input parameter: oldZip and newZip, and it updates the zipcodes table by replacing all oldZip wit

Cursor variables as parameters, Cursor Variables As Parameters You can... Cursor Variables As Parameters You can declare the cursor variables as the formal parameters of the functions and procedures. In the illustration below, you define the REF CUR

Definition of from - sql, Definition of FROM - SQL Recall that the ope... Definition of FROM - SQL Recall that the operand of FROM is denoted by a commalist, each element of that commalist being a table expression optionally accompanied by a range v

Effects of null for multiple assignments - sql, Effects of NULL for Multipl... Effects of NULL for Multiple Assignments - SQL If the row expression given as the source for a multiple assignment evaluates to NULL, then NULL is assigned to each target. If

%rowcount, %ROWCOUNT When its cursor or cursor variable is opened, the... %ROWCOUNT When its cursor or cursor variable is opened, the %ROWCOUNT is zeroed. Before the first fetch, the %ROWCOUNT yields 0. Afterward, it yields the number of rows fetche

Relational schema, query to Find the account numbers of all customers whose... query to Find the account numbers of all customers whose balance is more than 10,000 $

When or then key constraints, WHEN or THEN Key Constraints Suppose a t... WHEN or THEN Key Constraints Suppose a table has two columns representing a period of time throughout which the information conveyed by the other columns is recorded as having

Updating a variable, Updating a Variable Assignment of an attribute va... Updating a Variable Assignment of an attribute value in a variable of a structured type Synatx: SET SN.C = 'S2'; As in Example the entire statement is equivalent to a