Object type

From: Andreas Schwaiger <andreas.schwaiger_at_strasser.at>
Date: Tue, 22 Feb 2000 19:27:19 +0100
Message-ID: <951244200.599037@medsvc01.kabsi.at>

Hi all,

I have following table:

 Name                                                  Null?    Typ
 ----------------------------------------------------- -------- =


----------------


--------------------


 IX_AB_KA_ID                                           NOT NULL =
NUMBER(10)
 IX_AB_KA_STARTID                                      NOT NULL =
NUMBER(10)
 IX_AB_KA_ENDID                                        NOT NULL =
NUMBER(10)
 IX_AB_KA_BESCHREIBUNG                                          =
VARCHAR2(100)
 IX_AB_KA_BEWERTUNG_VOR                                NOT NULL =
NUMBER(15,6)
 IX_AB_KA_BEWERTUNG_ZURUECK                            NOT NULL =
NUMBER(15,6)
 IX_AB_KA_LAENGE                                       NOT NULL =
NUMBER(10,6)
 IX_AB_KA_RICHTUNG                                              NUMBER
 IX_AB_KA_IDX                                          NOT NULL =
NUMBER(10)
 IX_AB_KA_LEV_START                                             =
NUMBER(2)
 IX_AB_KA_LEV_END                                               =
NUMBER(2)
 IX_AB_KA_MAPKEY                                       NOT NULL =
VARCHAR2(30)
 IX_AB_KA_ROADCLASS                                             =

NUMBER(3) and following object:

 Name                                                  Null?    Typ
 ----------------------------------------------------- -------- =


----------------


--------------------


 IX_AB_KA_ID                                           NOT NULL =
NUMBER(10)
 IX_AB_KA_STARTID                                      NOT NULL =
NUMBER(10)
 IX_AB_KA_ENDID                                        NOT NULL =
NUMBER(10)
 IX_AB_KA_BESCHREIBUNG                                          =
VARCHAR2(100)
 IX_AB_KA_BEWERTUNG_VOR                                NOT NULL =
NUMBER(15,6)
 IX_AB_KA_BEWERTUNG_ZURUECK                            NOT NULL =
NUMBER(15,6)
 IX_AB_KA_LAENGE                                       NOT NULL =
NUMBER(10,6)
 IX_AB_KA_RICHTUNG                                              NUMBER
 IX_AB_KA_IDX                                          NOT NULL =
NUMBER(10)
 IX_AB_KA_LEV_START                                             =
NUMBER(2)
 IX_AB_KA_LEV_END                                               =
NUMBER(2)
 IX_AB_KA_MAPKEY                                       NOT NULL =
VARCHAR2(30)
 IX_AB_KA_ROADCLASS                                             =

NUMBER(3) i created a nested table type with this object:

how can i fill this table with data of my database table??

thanks for helping

Andi Schwaiger Received on Tue Feb 22 2000 - 12:27:19 CST