Answer Posted / ajit

declare
cursor c1
is
select * from emp;
i c1%rowtype;
begin
open c1;
loop
fetch c1 into i ;
exit when c1%notfound;
end loop;
dbms_output.put_line(c1%rowcount);
close c1;
end;

What are pl sql procedures?

960

---

what is error ora-03113: end-of-file on communication channel?

1081

---

what is 'mysqlcheck'? : Sql dba

958

---

What is the difference between joins?

974

---

What is implicit cursor in pl sql?

1026

---

what is a stored procedure? : Sql dba

1051

---

Write a sql query to find the names of employees that begin with ‘a’?

950

---

What is the difference between join and natural join?

880

---

Why do we use sql constraints?

1122

---

Why do you partition data?

965

---

Advantages and disadvantages of stored procedure?

1057

---

Why do we create stored procedures & functions in pl/sql and how are they different?

887

---

how can we encrypt and decrypt a data present in a mysql table using mysql? : Sql dba

1123

---

What are the types of queries in sql?

1014

---

what is the difference between ereg_replace() and eregi_replace()? : Sql dba

1071

---