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
- 4961 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 |
Can anyone give me information about oracle certification
Explain about functional dependency and its relation with table design?
What are the various constraints used in oracle?
What is a Data File ?
What is an Index ? How it is implemented in Oracle Database ?
How to export your connection information to a file?
How does one get the view definition of fixed views/tables?
What is SQL Tuning Advisor in Oracle?
What is a shared pool?
What is the effect of setting the value 'FIRST_ROWS' for OPTIMIZER_GOAL parameter of the ALTER SESSION command ?
What is define in oracle?
What is rowid and rownum in oracle?
Oracle General 
