Answer / 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;

How to change user password in oracle?

0 Answers  

---

What WHERE CURRENT OF clause does in a cursor?

2 Answers  

---

write a sql query following source looking like below column1 column2 101,102,103 abc,def,ghi 1001,1002,1003 a,b,c i want the output column1 column1 101 abc 102 def 103 ghi 1001 a 1002 b 1003 c

1 Answers   KPIT,

---

How do I use os authentication with weblogic jdriver for oracle and connection pools?

0 Answers  

---

24. Display the order number for all orders whose average item cost is greater than the overall average item cost across all orders.

2 Answers   Wipro,

---

Please help me how to write a Query to change the primary key constraint from 1 attribute to another attribute in a table

3 Answers  

---

what is meant by magic query

0 Answers  

---

Explain the function of optimizer in oracle?

0 Answers  

---

definition of cluster and non-clustered index?

0 Answers   CSS,

---

how to insert the image in table

2 Answers  

---

Please explain me all types of Data models. Also give me the details if each model can have other name.for example:schematic data model is also known as conceptual data model and entity relation data model.

0 Answers  

---

Explain user account with reference to oracle.

0 Answers  

---