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;

explain advantages of innodb over myisam. : Sql dba

636

---

What will you get by the cursor attribute sql%rowcount?

545

---

How to write html code in pl sql?

571

---

Can we use pl sql in mysql?

511

---

how do you know if your mysql server is alive? : Sql dba

588

---

---

How do I get sql certification?

521

---

Can we call stored procedure in function?

544

---

How can we debug in PL/SQL?

651

---

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

515

---

How is use pl and sql?

547

---

define sql insert statement ? : Sql dba

546

---

What are the disadvantages of not performing database normalization?

589

---

What is pl/sql table? Why it is used?

555

---

What is localdb mssqllocaldb?

608

---

How do I know if I have sql express or standard?

591

---