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 is bind reference and how can it be created?

1070

---

how to calculate expressions with sql statements? : Sql dba

1096

---

Why truncate is used in sql?

1044

---

What is package in pl sql?

1086

---

Can a foreign key be null?

1144

---

How can check sql version from command line?

1139

---

What is indexing in sql and its types?

1141

---

What is a string data type in sql?

1102

---

What is dialect in sql?

987

---

What is parameter substitution in sql?

1081

---

Can a view be mutating? If yes, then how?

1088

---

How to read xml file in oracle pl sql?

951

---

Is primary key always clustered index?

1067

---

how to convert character strings to numeric values? : Sql dba

1168

---

What is pl sql code?

1106

---