Question: I need to see a sample stored
procedure.
Answer: Here is an example stored procedure.
Note the semi-colons after each statement and the declare, begin and
end delimiters.
declare
n_1 number := 5;
n_2 number := 0;
begin
n_1 := n_1/n_2; -- divide by zero
dbms_output.put_line(n_1);
end;
/
 |
|
Get the Complete
Oracle SQL Tuning Information
The landmark book
"Advanced Oracle
SQL Tuning The Definitive Reference" is
filled with valuable information on Oracle SQL Tuning.
This book includes scripts and tools to hypercharge Oracle 11g
performance and you can
buy it
for 30% off directly from the publisher.
|
