how table is defined in plsql table? how can i select
column from plsql table?
can i use select * from plsql table type?
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 group functions be mixed with non-group selection fields?
Is oracle a programming language?
What do you mean by a tablespace?
What is an oracle and why it is used?
What is the difference between hot backup and cold backup in oracle?
How to select the name of employee who is getting maximum sal with out using subquery
Explain about achiever in sql?
How to export data with a field delimiter?
Differentiate between post-database commit and post-form commit?
HOW TO DISPLAY MAXIMUM SALARIES FROM EMP DEPARTMENT VISE ALONG WITH DEPARTMENT NAMES? E.g EMP,DEPT
5 Answers College School Exams Tests, DELL,
Find all employees in Dept “Marketing”.
How to create a testing table in oracle?