how table is defined in plsql table? how can i select
column from plsql table?
can i use select * from plsql table type?
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
Can we call procedure inside function in oracle?
Explain parameter file in oracle.
How can we find out the current date and time in oracle?
What is Segment Advisor in Oracle?
what is reindexing?
What will be the syntax to find current date and time in format "yyyy-mm-dd"?
If youre unsure in which script a sys or system-owned object is created, but you know its in a script from a specific directory, what UNIX command from that directory structure can you run to find your answer?
Point out the difference between user tables and data dictionary?
How to put more than 1000 values into an oracle in clause?
What is the difference between formal parameters and actual parameters?
How can we delete duplicate rows in a table?
How to grant create session privilege to a user in oracle?
State the difference along with examples between Oracle 9i, Oracle 10g and Oracle 11i.
What is oracle rowcount?
How to start an oracle instance?