Answer Posted / avi007

cursor-
1 cursor is small memory area to perform selection on the
one or more table.
2 cursor is a variable which is 2 dimentional array, it is
handling, storing and processin multiple rows.
3 storing data temporarily.
4 fetching rows from top to bottom.
5 fetching row one at a time.

procedure -
1 procedure is an object of database.
2 need to compile and execute.
3 dml operation performed in the block.

Does a primary key have to be a number?

963

---

Which software is used for pl sql programming?

986

---

discuss about myisam index statistics collection. : Sql dba

951

---

what are the different index configurations a table can have? : Sql dba

996

---

What is difference between stored function and application function?

1200

---

Why we use join in sql?

973

---

What is the use of count (*) in sql?

1053

---

what are all different types of collation sensitivity? : Sql dba

982

---

What is cursor explain with example?

985

---

How much does a sql dba make? : SQL DBA

945

---

Is ms sql is free?

1020

---

What is dba in sql? : SQL DBA

1041

---

What is the trigger in sql?

953

---

What is a schema sql?

1152

---

What is the difference between delete, truncate and drop command?

1151

---