exception handling, set serveroutput on declare a number(5); b number(5); , PL-SQL Programming

exception handling, PL-SQL Programming

Assignment Help:

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;
/

Related Discussions:- exception handling

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

Using savepoints, Using Savepoints The scope of the savepoint is a tra...

Using Savepoints The scope of the savepoint is a transaction in which it is defined. The Savepoints defined in the major transaction are not related to the savepoints defined

Managing cursors, Managing Cursors The PL/SQL uses 2 types of cursors: ...

Managing Cursors The PL/SQL uses 2 types of cursors: implicit and explicit. The PL/SQL declares a cursor implicitly for all the SQL data manipulation statements, including th

Package standard in pl/sql, Package STANDARD package named STANDARD d...

Package STANDARD package named STANDARD defines the PL/SQL atmosphere. The package specification globally declares the exceptions, types, and subprograms that are available a

Parameter & keyword description - functions, Parameter & Keyword Descriptio...

Parameter & Keyword Description: function_name: The user-defined function is identifying by that keyword. parameter_name: This identifies the formal parameter that

Using aliases-declarations in sql, Using Aliases The Select-list items f...

Using Aliases The Select-list items fetched from a cursor related with the %ROWTYPE should have simple names or, if they are expressions, should have aliases. In the example bel

3cx pbx sync windows service, 3CX PBX sync Windows Service Project Descr...

3CX PBX sync Windows Service Project Description: !! You require access to a commercial version of the 3CX PBX system in order to be able to program the API !! !! You requ

Using extend - collection method, Using EXTEND To enlarge the size of ...

Using EXTEND To enlarge the size of a collection, use EXTEND. This process has 3 forms. The EXTEND appends one null element to a collection. And the EXTEND(n) appends n null e

First step at defining type sid in sql, First Step at defining type SID in ...

First Step at defining type SID in SQL CREATE TYPE SID AS ( C VARCHAR(5) ) ; Explanation: TYPE SID announces that a type named SID is being defined to the syst

Best practices/Data Warhousing, What are 3 good practices of modeling and/o...

What are 3 good practices of modeling and/or implementing data warehouses?

Write Your Message!

Name

Email id

Message

Verfication Code

User Account

All Pages

exception handling, PL-SQL Programming

Related Discussions:- exception handling

Definition of from - sql, Definition of FROM - SQL Recall that the ope...

Using savepoints, Using Savepoints The scope of the savepoint is a tra...

Managing cursors, Managing Cursors The PL/SQL uses 2 types of cursors: ...

Package standard in pl/sql, Package STANDARD package named STANDARD d...

Parameter & keyword description - functions, Parameter & Keyword Descriptio...

Using aliases-declarations in sql, Using Aliases The Select-list items f...

3cx pbx sync windows service, 3CX PBX sync Windows Service Project Descr...

Using extend - collection method, Using EXTEND To enlarge the size of ...

First step at defining type sid in sql, First Step at defining type SID in ...

Best practices/Data Warhousing, What are 3 good practices of modeling and/o...

Write Your Message!

Featured Services

Online Tutoring

Project Development

Exam Preparation

Course Help

Assignment Help

Popular Subjects

Assured A++ Grade

Academics

Major Subjects

Majors

Get In Touch

TERMS & POLICIES

HELP & SUPPORT