Answer Posted / hjhjnj

Column Type (i.e. %TYPE) is used to declare a field with the same type as that of a specified table’s column

Row type (i.e. %ROWTYPE) is used to declare a record with the same types as found in the specified database table, view or cursor

How many sql statements are used?

1010

---

What is dml statement?

954

---

1. is it possible to use the cursor atttibutes (%found ,% rowcount , %isopen , %notfound ) to our user defined cursor names ....... cursor cursor_name is select * from scott.emp if you use... cursor_name%found , %rowcount ,%isopen,%notfound...will it work... -------------------------- 2.what is the difference between the varray and index by table .. -------- 3. type type_name is table of number(8,3) index by binary_integer; identifier_name type_name; first , last , prior , next ,trim are the methods we can use it for the above type...simillary is there any way to apply for cursors... with thanks and regards..sarao...

2448

---

What is data type in database?

992

---

What are reports usually used for?

1023

---

What is 19 null in sql?

966

---

What is cursor and its types?

1073

---

What is the size of partition table?

1048

---

Is drop table faster than truncate?

990

---

What is difference between db2 and sql?

999

---

How delete all records from table in sql?

977

---

How do you determine the current isolation level? : Transact sql

1158

---

What are instead of triggers?

1046

---

What is the difference between an inner and outer join?

1012

---

What is composite primary key in sql?

996

---