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;

HI, Please let me know the syllabus for Oracle OCA and OCP Certification

2497

---

Explain table?

1115

---

Explain oracle data types with examples?

1028

---

What is meant by a deadlock situation?

1109

---

what is reindexing?

1676

---

How to check database size in Oracle?

1191

---

Explain the use of log option in exp command.

1121

---

what is the difference between substr and instr function in oracle?

1090

---

Explain the use of grant option in exp command.

1063

---

can u send the sql dumps to sivakumarr1987@gmail.com plz help me

3051

---

What is an oracle table?

988

---

What view(s) do you use to associate a users SQLPLUS session with his o/s process?

2353

---

Explain the use of analyse option in exp command.

1128

---

How to create a new table in oracle?

1155

---

Give the different types of rollback segments.

1031

---