Answer Posted / narenkumar reddy

create or replace procedure
procdure_name
cursor c1 is select count(*),month from table
is
begin
for i in c1
loop
dbms_output.put_line(i.count(*)||i.month)
end loop;
end;

What are primary key and foreign key and how they work?

925

---

How many scalar data types are supported in pl/sql?

974

---

What are the types of variables use in pl sql?

964

---

What is a constraint?

959

---

How many sql statements are used? Define them.

981

---

What is trigger explain it?

957

---

What is an index in sql with example?

917

---

What is procedure in pl sql?

976

---

What is insert command in sql?

1057

---

what is a foreign key ? : Sql dba

1023

---

How to take user input in pl sql?

1105

---

What does dml mean?

927

---

what is the difference between blob and text? : Sql dba

960

---

How do I count rows in sql?

946

---

Can we join more than 2 tables in sql?

943

---