Give an example of any procedure.
Answers were Sorted based on User's Feedback
Answer / dev lamani
create or replace procedure Data_Ho(region number,proc
number) is
Data_Not_there exception;
cnt number;
Begin
select count(*) into cnt
from vhub.op_fertilizer_sta_tran
where proc_monyr=proc and region_code=region;
if cnt>=0 then
insert into op_fertilizer_sta
select * from op_fertilizer_sta_tran
where proc_monyr=proc and region_code=region;
else
raise Data_not_there;
end if;
exception
when Data_not_there then
dbms_output.putline('There is no Data Available for this
month for Insertion'|| ' ' || proc);
End;
Is This Answer Correct ? | 6 Yes | 1 No |
Answer / sharath
CREATE OR REPLACE PROCEDURE pro_name
AS --We cna write AS/IS
BEGIN
DBMS_OUTPUT.PUT_LINE(’Hello World’);
END;
Is This Answer Correct ? | 2 Yes | 0 No |
We can write a procedure with or w/o using parameters.
For procedure the simplest ex. could be like as
SQL> create or replace procedure tr ---calling procedure
2 as
3 begin
4 in_emp; -- Called procedure
5 end;
6 /
in this procedure i am calling another procedure inside
that.
Is This Answer Correct ? | 3 Yes | 3 No |
Answer / deepa
SQL> BEGIN
2 DBMS_OUTPUT.PUT_LINE(’Hello World’);
3 END;
4 /
Is This Answer Correct ? | 1 Yes | 8 No |
how is exception handling handled in mysql? : Sql dba
what is self join and what is the requirement of self join? : Sql dba
what are the type of locks ? : Sql dba
What is the difference between left join and right join?
How many databases can sql express handle?
What is a Mapplet?
How to get the 3rd column(i.e all the data along with the column name)in a table?
Explain the uses of a database trigger?
explain advantages of innodb over myisam. : Sql dba
What are different types of sql?
What are the rules to be applied to nulls whilst doing comparisons?
How to fetch values from testtable1 that are not in testtable2 without using not keyword?