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 transaction control language (tcl)?

1070

---

What is posting?

990

---

Is mariadb a nosql database?

1005

---

how to use regular expression in pattern match conditions? : Sql dba

963

---

What is the difference between distinct and unique in sql?

873

---

Is there a way to automate sql execution from the command-line, batch job or shell script?

918

---

What is sql in oracle?

1002

---

How many types of keys are there in sql?

986

---

what are set operators in sql? : Sql dba

983

---

How can we debug in PL/SQL?

1090

---

What is rank () in sql?

882

---

how many sql ddl commands are supported by 'mysql'? : Sql dba

955

---

Can we rollback truncate?

944

---

how to calculate expressions with sql statements? : Sql dba

980

---

What is form and report?

926

---