how table is defined in plsql table? how can i select
column from plsql table?
can i use select * from plsql table type?



how table is defined in plsql table? how can i select column from plsql table? can i use select *..

Answer / 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

More Oracle General Interview Questions

What is system global area (sga) in oracle?

0 Answers  


What is the data type of dual table?

0 Answers  


7. Repeat query (7) but also display all clients who have never ordered anything.

1 Answers   Wipro,


How to export your own schema?

0 Answers  


Explain self joins in oracle?

0 Answers  


Shall I get Pro*C Compiler in Oracle-10g release ?

1 Answers  


How to view the data files in the current database?

0 Answers  


17. Display the order number and average item cost for each order.

1 Answers   Wipro,


select statement does not retrieve any records. what exception is raised?

2 Answers  


Explain an exception and its types?

0 Answers  


How can I see all tables in oracle?

0 Answers  


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

2 Answers   Verizon,


Categories
  • Oracle General Interview Questions Oracle General (1808)
  • Oracle DBA (Database Administration) Interview Questions Oracle DBA (Database Administration) (261)
  • Oracle Call Interface (OCI) Interview Questions Oracle Call Interface (OCI) (10)
  • Oracle Architecture Interview Questions Oracle Architecture (90)
  • Oracle Security Interview Questions Oracle Security (38)
  • Oracle Forms Reports Interview Questions Oracle Forms Reports (510)
  • Oracle Data Integrator (ODI) Interview Questions Oracle Data Integrator (ODI) (120)
  • Oracle ETL Interview Questions Oracle ETL (15)
  • Oracle RAC Interview Questions Oracle RAC (93)
  • Oracle D2K Interview Questions Oracle D2K (72)
  • Oracle AllOther Interview Questions Oracle AllOther (241)