EXCEPTION handling, PL-SQL Programming

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







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
Related Questions
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

Question: Consider the following relations (primary keys are underlined): AUTHOR (ANo, aname, address, speciality) PUBLISHER (PNo, pname, Location) BOOK (BNo, Title, ISBN,

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

(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

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. The procedure takes two input parameter: oldZip and newZip, and it updates the zipcodes table by replacing all oldZip wit

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 Syntax : INSERT INTO ENROLMENT VALUES (SID ('S4'), 'Devinder', CID ('C1'));

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 (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