Answer Posted / suresh somayajula

%Type is used to change the size of any datatype but only
for one record.

%Rowtype is used to declare a recoed that represents a
particular row of a table.

Explain raise_application_error.

1143

---

How do you take the union of two tables in sql?

1027

---

What are the advantages of stored procedure?

1038

---

What is localdb mssqllocaldb?

1106

---

what is oltp (online transaction processing)? : Sql dba

1125

---

What is the difference between stored procedure and view?

1062

---

Is nosql faster than sql?

1072

---

explain advantages of innodb over myisam. : Sql dba

1175

---

what is the difference between blob and text? : Sql dba

1061

---

What is rtm stands for?

1173

---

How to use distinct and count in sql query? Explain

1080

---

What are the types of triggers in sql?

1140

---

What is scope of pl sql developer in future?

1067

---

What is t sql used for?

1058

---

how can we find the number of rows in a table using mysql? : Sql dba

1123

---