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.......

How do you remove duplicates without using distinct in sql?

982

---

What is trigger and types?

1030

---

Is record in pl sql?

979

---

what is the command used to fetch first 5 characters of the string? : Sql dba

1639

---

What are stored procedures in mysql?

1019

---

What is a recursive join sql?

1077

---

Is grant a ddl statement?

901

---

Why indexing is needed?

991

---

Why is sharding used?

1003

---

Is join same as left join?

1042

---

How do I install sql?

1002

---

What is the usage of sql functions?

1147

---

What is the purpose of the sql select top clause?

1116

---

How do you declare a user-defined exception?

1029

---

how many tables will create when we create table, what are they? : Sql dba

1081

---