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 |
What is system global area (sga) in oracle?
What is the data type of dual table?
7. Repeat query (7) but also display all clients who have never ordered anything.
How to export your own schema?
Explain self joins in oracle?
Shall I get Pro*C Compiler in Oracle-10g release ?
How to view the data files in the current database?
17. Display the order number and average item cost for each order.
select statement does not retrieve any records. what exception is raised?
Explain an exception and its types?
How can I see all tables in oracle?
how can find the second max sal for every group(i.e i want group the data based on key and find the second max sal for every group