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 out parameter used for eventhough return statement can also be used in pl/sql?

1078

---

The in operator may be used if you know the exact value you want to return for at least one of the columns.

1133

---

when MSQL8.0 is in market

2078

---

What is trigger explain it?

1017

---

What is a system versioned table?

986

---

What is assignment operator in pl sql?

1038

---

Does sql use python?

1035

---

What type of database is cloud sql?

1102

---

which types of join is used in sql widely? : Sql dba

982

---

What is normalisation and its types?

1004

---

Which constraints we can use while creating database in sql?

1082

---

what are the nonstandard string types? : Sql dba

1139

---

How do you take the union of two tables in sql?

985

---

Why do we need unique key in a table?

957

---

i have 2 table table one 4 columns respective values a1 7,a2 6,a3 8 ,a4 12 & table two 4 colums respective values a1 7,a2 6,a3 8,a4 15.if table one & table two 3 colums same then 4th column values 1)Qes diff >5 then print 5 * diff value 2)Que diff <5 print 5

4025

---