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
- 4969 Views
- I also Faced
- E-Mail Answers
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;
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to check the oracle tns settings?
What are the general rules on data consistency?
Explain the use of rows option in imp command.
What language does oracle use?
How index is implemented in oracle database?
How to retrieve values from data fields in record variables?
How different is ms access and oracle?
Whats the benefit of dbms_stats over analyze?
What are the various types of snapshots ?
What is the usage of merge statement?
How to enter a new row into a table interactively?
How to find the duplicate rows count from employees table in oracle?
What is Data Dictionary Cache in Oracle?
What are the differences between interval year to month and interval day to second?
What is a tns service name?
