Give an example of any procedure.
Answer Posted / 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 |
Post New Answer View All Answers
how to drop an existing view in mysql? : Sql dba
What is mutating error?
What is an escape character in sql?
What is a crud api?
What is the difference between joins?
How to use sql statements in pl/sql?
- Types of triggers - View - Dcl - Procedures, packages, functions - Metasolve - Can use Dcl in triggers - package case study - Cursor and its types - triggers schedule - Wrap - Why we are using fetch and for in cursor. difference?
How can you know that statistics should be updated?
column A column b | output 10 7 | 10 5 8 | 8 7 -9 | 7 3 5 | 5 0 6 | 6 Write a sql query to print such output.
What is on delete set null?
what are all the common sql function? : Sql dba
what is union, minus and interact commands? : Sql dba
How to select unique records from a table?
What are sql injection vulnerabilities?
What are character functions?