Interested to Buy Any Domain ? << Click Here >> for more details...
how table is defined in plsql table? how can i select
column from plsql table?
can i use select * from plsql table type?
- 1 Answers
- 4968 Views
- I also Faced
- E-Mail Answers
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;
| Is This Answer Correct ? | 0 Yes | 0 No |
Does oracle charge for java?
How to define a specific record type?
How to change program global area (pga) in oracle?
What are the uses of Database Trigger ?
What is a dead lock in oracle?
what is RAID technology?which is better RAID 0+1 OR RAID 5?
How to change system global area (sga) in oracle?
what is partitioning? Types of partitioning. explain? what is the new kind of partitioning type introduced in 9i?
What is a package ? What are the advantages of package ?
How to use group functions in the select clause using oracle?
Which is better Oracle or MS SQL? Why?
I want a table like, no name address addr1 addr2 So i want columns like addr1,addr2 under address column. Can one please answer me. Advance Thanks.
Oracle General 
