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.

What are the two types of exceptions.

1105

---

how to convert dates to character strings? : Sql dba

1070

---

Where do we use pl sql?

943

---

What is embedded sql what are its advantages?

958

---

What are the types of optimization?

886

---

What is difference between procedure and trigger?

915

---

What is the maximum size of sqlite database?

1039

---

Does truncate need commit?

893

---

what are the differences between char and nchar? : Sql dba

1054

---

What is a boolean in sql?

944

---

How to fix oracle error ora-00942: table or view does not exist

955

---

what is a cursor? : Sql dba

972

---

What has stored procedures in sql?

991

---

what is normalization? : Sql dba

1015

---

What is an invalid partition table?

959

---