Answer Posted / pavan_1981

these two are used with cursors to store the returing
result from the query.
%TYPE:a variable is declared to be of %type when we are
referring to a single specific column.when we declare a
variable to be of %type of a column,the variable datatype
becomes the datatype of that column..here it can only one
datatype that of the column.

%ROWTYPE:same as above but takes a single row at a time and
can accomidate multiple datatypes.it can store whole row at
a time containing different datatypes.

What is the difference between subquery and correlated query?

1065

---

What is trigger in pl sql?

1001

---

describe mysql connection using mysql binary. : Sql dba

1066

---

What is the importance of sqlcode and sqlerrm?

1356

---

how many values can the set function of mysql take? : Sql dba

987

---

What is numeric function sql?

1061

---

where are cookies actually stored on the hard disk? : Sql dba

1030

---

How to return multiple rows from the stored procedure?

970

---

How to take user input in pl sql?

1163

---

How does stored procedure reduce network traffic?

1008

---

Is there a way to automate sql execution from the command-line, batch job or shell script?

970

---

What is latest version of sql?

1044

---

List the ways to get the count of records in a table?

900

---

What is PL/SQL Records?

1189

---

What does the base_object_type column shows in the user.triggers data dictionary view?

1052

---