Answer Posted / abapdeveloper09

1. Define a TABLE data type
TYPE type_name IS TABLE OF
(column_type | variable%TYPE
| table.column%TYPE | table%ROWTYPE
INDEX BY BINARY_INTEGER);

2 Declare a variable of that type
identifier type_name;

Assume the PLsql table (emp_table_type) has emp's first
name and index columns and you want to display this column
data (Emp's first name)

TYPE type_name IS TABLE OF
employee.firstname%TYPE
INDEX BY BINARY_INTEGER;

emp_table_type type_name;

Load data into emp_table_type table

-- Display emp's first name data
FOR index in EMP_table_type.FIRST..EMP_table_type.LAST
LOOP
DBMS_OUTPUT.PUT_LINE(EMP_table_type(index));
END LOOP;

What are the different windows events activated at runtime ?

2941

---

Is it possible to center an object horizontally in a repeating frame that has a variable horizontal size ?

2421

---

Explain temporal data types in oracle

1133

---

What is a connect identifier?

1084

---

Can the query output be sorted by multiple columns in oracle?

1049

---

What are the data types in oracle?

1095

---

Explain the use of constraints option in exp command.

1079

---

Please explain compound trigger in oracle?

1107

---

What is the usage of synonyms?

1210

---

How to count duplicated values in a column in oracle?

1101

---

what are the default admin accounts in Oracle 10g ?

1019

---

What is a tns file?

1040

---

What is a database table in oracle?

1068

---

How many file formats are supported to export data?

1263

---

How to test null values?

1154

---