4 Replies Latest reply on Aug 24, 2009 2:11 PM by Darthvader-647181

    how to select records from a type object

    Darthvader-647181
      CREATE TABLE BOOKING_ITERATION
      (
        SK_BOOKING_ID               NUMBER(20)        NOT NULL,
        BOOKING_TRANS_DATE          DATE              NOT NULL,
        LAST_CALCULATED_DATE        DATE,
        MAX_CALCULATED_TOLERANCE    NUMBER(2),
        CALCULATION_SUCCESSFUL_IND  VARCHAR2(1 BYTE),
        BOOKING_CALC                BOOKING_CALC_ATTRIBUTES_T
      )
      
      
      CREATE OR REPLACE /* Formatted on 24/06/2009 14:57:50 (QP5 v5.115.810.9015) */
      TYPE booking_calc_attributes_t AS OBJECT(
        booking_rec                      top_bkg_basic_rec_t,
      
        accom_costs_initialsed           VARCHAR2(1),
        flight_costs_initialsed          VARCHAR2(1),
        fin_details_initialsed           VARCHAR2(1),
        business_transaction_id          INTEGER,
        accom_unit_service_id            INTEGER,
        product_id                       INTEGER,
        subproduct_id                    INTEGER,
        subproduct_code                  VARCHAR2(3)
      )
      now my requirement is to select the values from BOOKING_ITERATION table where product_id = 101
      can you please advise me on how to do this.

      Regards