Give an example of any procedure.

Categories >> Software >> Databases >> SQL PLSQL
Suggest New Category

Question Posted / abc

5 Answers
14882 Views
Accenture, iFlex, Wipro, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

Give an example of any procedure...

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

Give an example of any procedure...

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

Give an example of any procedure...

Answer / roopesh kumar

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

Give an example of any procedure...

Answer / nagendra

put_line is an example of procedure

Is This Answer Correct ?

0 Yes

3 No

Give an example of any procedure...

Answer / deepa

SQL> BEGIN
2 DBMS_OUTPUT.PUT_LINE(’Hello World’);
3 END;
4 /

Is This Answer Correct ?

1 Yes

8 No

Post New Answer