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.

How do I save the results of sql query in a file?

1010

---

Can we use insert statement in function?

1044

---

What is sql*loader?

1277

---

What are the types of dbms?

1018

---

How many scalar data types are supported in pl/sql?

1101

---

How to display Row Number with Records in Oracle SQL Plus?

1090

---

Can triggers stop a dml statement from executing on a table?

1155

---

What are character functions?

1136

---

What is mutating table error?

1235

---

what is the use of friend function? : Sql dba

1056

---

Can a foreign key be a duplicate?

958

---

What are sql commands?

1061

---

Is sql a oracle?

1016

---

what is cross join? : Sql dba

1044

---

What are the 3 types of behavioral triggers?

1309

---