posted 23 years ago
Hi,
I have a database schema created using the following SQL statements:
create or replace type rows_type as table of varchar2(200);
create or replace type line_type as object (
r_id number(10),
m_id number(10),
rating varchar2(10),
row_num number(3),
column_values rows_type
);
create table result_row of line_type (
R_ID NOT NULL,
M_ID NOT NULL,
RATING NOT NULL,
ROW_NUM NOT NULL)
nested table column_values store as result_column_values
;
I am quite new to this stuff. I need to know how I can insert values into
the result_row table.
Thanks a lot.
Mathew
[ April 28, 2002: Message edited by: Mathew Kuruvilla ]