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;

how to drop an existing view in mysql? : Sql dba

1105

---

What is mutating error?

1007

---

What is an escape character in sql?

1073

---

What is a crud api?

992

---

What is the difference between joins?

1094

---

How to use sql statements in pl/sql?

1195

---

- 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?

1894

---

How can you know that statistics should be updated?

1128

---

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.

7490

---

What is on delete set null?

1135

---

what are all the common sql function? : Sql dba

1106

---

what is union, minus and interact commands? : Sql dba

1255

---

How to select unique records from a table?

1110

---

What are sql injection vulnerabilities?

1027

---

What are character functions?

1141

---