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

Join and and in sql, JOIN and AND in SQL In this Section is all about ... JOIN and AND in SQL In this Section is all about one operator, JOIN. SQL's closest counterpart, NATURAL JOIN, has already been covered. Here we look at several other "join" op

I want database development with analysis tools, Project Description: I ... Project Description: I want a database for large governmental and private data sets on one country that will be easily extended to other countries in the future. Also, the datab

Iterative control: loop statement, Iterative Control: LOOP  Statements T... Iterative Control: LOOP  Statements The LOOP statement executes a series of statements multiple times. There are 3 forms of LOOP statements: LOOP, WHILE-LOOP, & FOR-LOOP. LOOP

Updating variables, Updating Variables For assignment, SQL uses the ke... Updating Variables For assignment, SQL uses the key word SET, as in SET X = X + 1 (read as "set X equal to X+1") rather than X: = X + 1 as found in many computer languages.

Pascal programming and mysql programming, I have a Pascal Source file that ... I have a Pascal Source file that needs to be compiled into a Service. In addition, there are various functions (Pascal Procedures I guess) that need to be created to Read and Write

Explicit cursors, Explicit Cursors The set of rows returned by the que... Explicit Cursors The set of rows returned by the query can include zero, one, or multiple rows, depending on how many rows meet your search criteria. Whenever a query returns

Using trim - collection method, Using TRIM This process has two forms.... Using TRIM This process has two forms. The TRIM removes an element from the end of the collection. The TRIM(n) removes the n elements from the end of the collection. For e.g.

Oracle 9i features, Bitmap Join Indexes - This feature will increase th... Bitmap Join Indexes - This feature will increase the performance and detains the size and format of your databases in data Character Semantics and Globalization -This featur

Updating by replacement, Updating by replacement Syntax: UPDAT... Updating by replacement Syntax: UPDATE ENROLMENT SET Name = 'Ann' WHERE StudentId = SID ('S1'); Note the use of SET, as already noted in connection with direct a

In operator-comparison operators, IN Operator The operator IN tests the ... IN Operator The operator IN tests the set membership. This means "equal to any member of." The set may have nulls, but they are ignored. For illustration, the statement below do