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;

What is the use of function in sql?

1029

---

What is crud sql?

924

---

What is the use of index in hive?

963

---

how do you login to mysql using unix shell? : Sql dba

1018

---

Explain what is a view?

997

---

What is a left join?

890

---

How would you pass hints to the sql processor?

921

---

What is multiple columns?

1002

---

What is the size of partition table?

992

---

What are all the ddl commands?

1118

---

Is it possible to link two groups inside a cross products after the cross products group has been created?

955

---

what are local and global variables and their differences? : Sql dba

1010

---

What is the difference between delete, truncate and drop command?

1063

---

What is the difference between a primary key and a unique key?

1001

---

Can we create clustered index without primary key?

901

---