Answer / meher

The main difference between cursor FETCH and FOR LOOP is as
below :
In case of cursor FETCH the cursor will open atleast once
but in case of cursor FOR LOOP the cursor will may or
maynot be open.

Answer / kiran kumar

The cursor FOR LOOP implicitly declare loop index as a
record of %ROWTYPE open a cursor implicity and repeatedly
fetch the records from the active set into the field of
record, then close the cursor implictly all rows have been
processed.
In case of cursor FETCH explicity open a cursor, fetch the
records and close the cursor.

Answer / paras jain

in fetch exit condition is must in for loop no need.

What is the execution plan in sql?

0 Answers  

---

how to get the third quarter of employee details from emp?

2 Answers   CompuTech,

---

What are the different types of a subquery?

0 Answers  

---

Write a query to display the current date in sql?

0 Answers  

---

How do I run a sql script?

0 Answers  

---

i have a table like this. cityno cityname mails 1 BANGALORE 8KM 2 HSR LAYOUT 20KM 3 MEJISTIC 30KM 4 JAYADEVA 55KM 5 ITPL 80KM 6 HEBBAL 115KM I HAVE DATA LIKE THIS I WANT O/P LIKE THIS DISTANCE NO.OFCITY 0-50KM 3 51-100KM 2 101-150KM 4 AND SO ON pls give me answer. i want urgent

6 Answers  

---

How to move files from one directory to another in pl sql?

0 Answers  

---

we have a package and we have grants to execute that package inside of that we have table, here we don't have privileges to this table? whether this package will execute or not?

3 Answers   TCS,

---

How to run pl/sql statements in sql*plus?

0 Answers  

---

What is pl/sql language case sensitive?

0 Answers  

---

Can we call stored procedure in function?

0 Answers  

---

What do you mean by “trigger” in sql?

0 Answers  

---