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

Does inner join return duplicate rows?

1036

---

What is recursive stored procedure?

1141

---

what is a materialized view? : Sql dba

1126

---

Explain architecture of sql server notification services?

1105

---

Does sql profiler affect performance?

1044

---

write an sql query to get third maximum salary of an employee from a table named employee_table. : Sql dba

1015

---

What are the three forms of normalization?

1092

---

What is nested table in pl sql?

1121

---

Can we create view in stored procedure?

1021

---

What is case function?

1088

---

What is the difference between cluster and non-cluster index?

1154

---

Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me

2067

---

What is keys and its types?

1119

---

What are the different types of database management systems?

1036

---

What is your daily office routine?

2315

---