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 do you mean by “trigger” in sql?

1036

---

What is difference between stored procedure and trigger?

1089

---

How can use stored procedures in sql?

1102

---

Mention what does plvtab enables you to do when you showthe contents of pl/sql tables?

1127

---

Which sql statement is used to delete data from a database?

919

---

How many subqueries can be nested in a statement?

951

---

What is a dirty read sql?

1070

---

Differences between Oracle 9i and 10g (Probably in terms of SQL and PL/SQL)?

3536

---

List the different type of joins?

1031

---

What is the difference between partition and index?

949

---

What are the types of triggers in sql?

1043

---

what is the difference between clustered and non clustered index in sql? : Sql dba

1079

---

Explain autonomous transaction.

1121

---

Mention what are different methods to trace the pl/sql code?

1146

---

What is fmtonly in sql?

1032

---