This discussion is archived
4 Replies Latest reply: Aug 24, 2009 7:04 AM by 94799 RSS

how to select records from a type object

650184 Pro
Currently Being Moderated
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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points