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
- 4498 Views
- I also Faced
- E-Mail Answers
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
What is translate in oracle?
How do I use unicode codesets with the weblogic jdriver for oracle driver?
What is blob data type in oracle?
Explain what are the type of synonyms?
what is reindexing?
How to view existing locks on the database?
How to create a new view in oracle?
What is the fastest query method to fetch data from the table?
Explain the use of compress option in exp command.
How different is ms access and oracle?
How to use attributes of the implicit cursor in oracle?
Does facebook use oracle?
Is there a function to split a string in plsql?
What is merge statement used for?
What are the uses of a database trigger?
