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 |
How to create a new table by selecting rows from another table?
How to view existing locks on the database?
How to use values from other tables in update statements using oracle?
How to use like conditions in oracle?
How to count groups returned with the group by clause in oracle?
Why cursor variables are easier to use than cursors?
How do you increase the OS limitation for open files (LINUX and/or Solaris)?
how many outer joins are used in a single sql query? is there any limitations for using of outer joins?
2 Answers BOB Technologies, Cap Gemini, IBM,
Explain the truncate in oracle?
How to create a new table in oracle?
What is self-referential integrity constraint ?
What is integrity and what is constraint??Explain with example