Answer Posted / senthil kumar

Hi Ramaprasad 'select max(rownum) from emp; ' this is passible
but

declare
cursor c1(dpno emp.deptno%type)is select * from emp where
deptno=dpno;
i c1%rowtype;
begin
open c1(dpno);
loop
fetch c1 into i ;
exit when c1%notfound;
dbms_output.put_line(c1%rowcount);
end loop;
close c1;
end;

this is NOT Passible , because this one just show all records Not count it.......

What are the types of variable use in pl sql?

1067

---

What is a file delimiter?

1082

---

Explain the types of joins in sql?

1028

---

Why select is used in sql?

1011

---

How do I view a procedure in sql?

959

---

What schema means?

884

---

what is uncommittable transactions? : Transact sql

993

---

What are the different types of functions in sql?

1046

---

how to do backup entire database? : Transact sql

1134

---

GLOBAL TEMPORARY TABLE over Views in advantages insolving mutating error?

3038

---

Is mariadb nosql?

1037

---

What is microsoft t sql?

937

---

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

1075

---

How do I debug a stored procedure?

1107

---

What is trigger in sql? Explain

984

---