EXCEPTION handling, set serveroutput on declare a number(5); b number(5); c, 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

PROCEDURES AND FUNCTIONS QURIES, i NEED THE QURIES TO SOME OF THE PROBLEMS ...

i NEED THE QURIES TO SOME OF THE PROBLEMS USING plsql

Semidifference via not in and a subquery , Semidifference via NOT IN and a ...

Semidifference via NOT IN and a subquery SELECT StudentId FROM IS_CALLED WHERE Name = 'Devinder' AND StudentId NOT IN (SELECT StudentId FROM IS_ENROLLED_ON WHER

Scope and visibility- pl/sql, Scope and Visibility The References to an ...

Scope and Visibility The References to an identifier are resolved according to its visibility and scope. The scope of an identifier is that area of a program unit (subprogram, b

Anatomy of a command, Anatomy of a Command Figure, showing a simple S...

Anatomy of a Command Figure, showing a simple SQL command, is almost identical to its counterpart in the theory book. The only difference arises from the fact that SQL uses a

Solve the business problems using sql, Use the MASCOT tables CREDITRS, PORD...

Use the MASCOT tables CREDITRS, PORDS and PAYMENTS to write SQL queries to solve the following business problems. These tables / data are available to you via the USQ Oracle server

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

Using inner join, Using INNER JOIN INNER JOIN is used to retrieve the ...

Using INNER JOIN INNER JOIN is used to retrieve the data from all tables listed based on a condition of equality listed after keyword ON. If the condition is not meet, rows ar

Committing and rolling back - autonomous transaction, Committing and Rollin...

Committing and Rolling Back The COMMIT and ROLLBACK end the active autonomous transaction but do not exit the autonomous routine. As the figure shows, if one transaction ends,

Passing cursor parameters, Passing Cursor Parameters You use the OPEN ...

Passing Cursor Parameters You use the OPEN statement to pass the parameters to a cursor. Unless you want to accept the default values, each proper parameter in the cursor decl

Pass the nulls to a dynamic sql, Pass the nulls to a dynamic SQL: Pas...

Pass the nulls to a dynamic SQL: Passing Nulls: Assume that you want to pass the nulls to a dynamic SQL statement. For illustration, you may write the EXECUTE IMMEDIATE

Write Your Message!

Name

Email id

Message

Verfication Code

User Account

All Pages

EXCEPTION handling, PL-SQL Programming

Related Discussions:- EXCEPTION handling

PROCEDURES AND FUNCTIONS QURIES, i NEED THE QURIES TO SOME OF THE PROBLEMS ...

Semidifference via not in and a subquery , Semidifference via NOT IN and a ...

Scope and visibility- pl/sql, Scope and Visibility The References to an ...

Anatomy of a command, Anatomy of a Command Figure, showing a simple S...

Solve the business problems using sql, Use the MASCOT tables CREDITRS, PORD...

Sql query for testing triggers and stored procedures , Description: Dem...

Using inner join, Using INNER JOIN INNER JOIN is used to retrieve the ...

Committing and rolling back - autonomous transaction, Committing and Rollin...

Passing cursor parameters, Passing Cursor Parameters You use the OPEN ...

Pass the nulls to a dynamic sql, Pass the nulls to a dynamic SQL: Pas...

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