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 is the difference between nested table and varray?

523

---

What is the difference between function, procedure and package in pl/sql?

561

---

How do you break a loop in pl sql?

526

---

Why should I use postgresql?

566

---

What is a crud api?

502

---

---

How can use stored procedures in sql?

583

---

What is a string data type in sql?

514

---

Is sqlexception checked or unchecked?

538

---

How many sql are there?

514

---

What does plv msg allows you to do?

679

---

What is the difference between function and procedure in pl/sql?

541

---

What is trigger price?

542

---

Why is partition used in sql?

550

---

How do I start pl sql?

492

---

What is mdb stand for?

556

---