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:14:20 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

Using count, Using COUNT The COUNT returns the number of elements that... Using COUNT The COUNT returns the number of elements that a collection presently contains. For instance, when a varray projects contains 15 elements, then the following IF con

Write sql code that will create the writes table, Question: Consider th... Question: Consider the following relations (primary keys are underlined): AUTHOR (ANo, aname, address, speciality) PUBLISHER (PNo, pname, Location) BOOK (BNo, Title, ISBN,

Write a pl/sql anonymous block that accepts an employee id, Based on the EM... Based on the EMPLOYEE table created in Assignment #1, write a PL/SQL anonymous block that accepts an employee ID from the user input and finds whether the employee ID is in the EMP

What are decision support systems, (a) What are decision support systems, a... (a) What are decision support systems, and what role do they play in the business environment? (b) Data warehousing is defined as "a subject-oriented, integrated, non-volatile c

produce vertical output format- oracle, Create a Oracle procedure to produ... Create a Oracle procedure to produce vertical output format when selecting rows from a database table.

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

Sql query for testing triggers and stored procedures , Description: Dem... Description: Demonstrate your knowledge of PL/SQL programming by writing and thoroughly testing triggers and stored procedures associated with an e-commerce application that pr

Updating by insertion, Updating by insertion Syntax : INSERT IN... Updating by insertion Syntax : INSERT INTO ENROLMENT VALUES (SID ('S4'), 'Devinder', CID ('C1'));

Creating Views, Create a view named CustomerAddresses that shows the shippi... Create a view named CustomerAddresses that shows the shipping and billing addresses for each customer in the MyGuitarShop database. This view should return these columns from the

Negation - sql, Negation (NOT, ¬) - SQL There are three rows instead o... Negation (NOT, ¬) - SQL There are three rows instead of just two. As you can see, ¬ p is defined as in two-valued logic (2VL) when p is either true or false, but ¬ (unknown) i