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
- 4221 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 |
How do we get field detail of a table?
What are the uses of synonyms?
select trunc(round(156.00,-1),-1) from dual;
List the parts of a database trigger.
What is STATSPACK tool?
How would you change old and new values in an insert, delete and update triggers?
what is the use of ondelete cascade?
What are the major difference between truncate and delete?
defination of bitmap index
What are the attributes of the cursor?
How to drop an index?
Can the query output be sorted by multiple columns in oracle?
Oracle General 
