What steps should a programmer should follow for better tunning of the PL/SQL blocks?

We have a trigger on database. In the trigger body we have created a body using dbms_output.put_line(********) ;How to fire this ?

ushaudayam

 Profile Answers by ushaudayam Questions by ushaudayam

• Aug 22nd, 2008

Trigger is a pl/sql block that is automatically invoked on an event, when any DML command is used on corresponding table.Triggers are classified into different categories based on when they are to be ...

Answer Question  Select Best Answer

In PL/SQL if we write select statement with INTO clause it may return two exceptions NO_DATA_FOUND or TOO_MANY_ROW .To avoid these execeptions. How do you write SQL statement in alternative way?

Ananda Kumar Behera

• Nov 12th, 2013

To avoid use:

Code
DECLARE a variable
SELECT COUNT(*) INTO num WHERE <Condition OF your data retreival FOR SELECT INTO statement>;
IF num==1 THEN
EXECUTE your SELECT INTO statement
END IF

tinku981

 Profile Answers by tinku981 Questions by tinku981

• Jun 16th, 2013

We can use explicit cursor to avoid Oracle exception - NO_DATA_FOUND and TOO_MANY_ROWS.

Answer Question  Select Best Answer