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
- 4370 Views
- I also Faced
- E-Mail Answers
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 are the composite date types in oracle?
Explain 1st, 2nd, 3rd normalization form of data base
If a table column has is UNIQUE and has NOT NULL, is it equivalent to a PRIMARY KEY column?
How to get the Installed Oracle Version Information ?
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
Explain implicit cursor.
Explain what are the characteristics of data files?
I have created one package with out procedures in package specification and in package body i have used 2 procedures. is it compile????
What is the difference between the Oracle ODBC driver and a Microsoft ODBC (Open Database Connectivity) Driver?
what is the syntax of update command?
How do I limit the number of rows returned by an oracle query after ordering?
How to Identify the previously inserted/updated records in already populated table.
Oracle General 
