Answer / Meenakshi Pal

In PL/SQL, %rowtype and %TYPE are used for working with records. n%rowtype is a predefined attribute that allows you to declare a record of the same type as a table or a cursor. It helps in iterating over each row of a record without explicitly knowing column names.nOn the other hand, %TYPE provides the datatype and size information of a variable in PL/SQL. It can be used to declare variables whose data type is the same as that of a column or a table.

Does user triggers have entry for trigger with compilation errors?

1 Answers  

---

What is sharding in sql?

1 Answers  

---

Why do we need databases?

1 Answers  

---

What is trigger in pl sql?

1 Answers  

---

What is sql in java?

1 Answers  

---

how is myisam table stored? : Sql dba

1 Answers  

---

What is sequence in sql?

1 Answers  

---

What are character functions in sql?

1 Answers  

---

What is difference between cursor and ref cursor?

1 Answers  

---

Can i possible to see Table Details ? Ex : Table Name Date Time User Emp May/18/2010 12:59pm Scott

3 Answers  

---

What is dml with example?

1 Answers  

---

in oracle 10g sw after compiling procedure how to pass parameter values ,if we (v_empid out number)how to give empid after successful compilation program.This site exact suitable for 10g with respect to question & answer same format , im trying sql browser & sql command prompt using exec procedure name & respective parameters.

1 Answers  

---