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 |
What are the disadvantages of file system?
What is 19 null in sql?
Can we use pl sql in mysql?
what are the advantages of mysql in comparison to oracle? : Sql dba
Is ms sql traffic encrypted?
what is the difference between char and varchar data types? : Sql dba
What is mutating error in pl sql?
Can sql function call stored procedure?
Is sql better than access?
SQL Tuning, Oracle Server 10g: Why is the following hint invalid? SELECT /*+ first_rows parallel(table_name,paral_number)*/
Create a procedure to delete certain records from a table and display the total number of records deleted in this process. (Condition for deletion can be of ur choice, for instance delete all records where eid='')
What is pl/sql tables?