1 Reply Latest reply: Nov 18, 2012 6:43 AM by 695721 RSS

    multiple select value

    695721
      Dears ,
      i have 3 tables
      CREATE TABLE  "SERVICES" 
         (     "SERVICE_ID" NUMBER, 
           "SERVICE_NAME" VARCHAR2(50), 
            CONSTRAINT "SERVICES_PK" PRIMARY KEY ("SERVICE_ID") ENABLE
         )
      /
      CREATE TABLE  "DEMO_CUSTOMERS" 
         (     "CUSTOMER_ID" NUMBER NOT NULL ENABLE, 
           "CUST_FIRST_NAME" VARCHAR2(20) NOT NULL ENABLE, 
           "CUST_STREET_ADDRESS1" VARCHAR2(60),
           "CUST_CLASS" VARCHAR2(2), 
           "CUST_TYPE" NUMBER(1,0), 
            CONSTRAINT "DEMO_CUSTOMERS_PK" PRIMARY KEY ("CUSTOMER_ID") ENABLE, 
            CONSTRAINT "DEMO_CUSTOMERS_UK" UNIQUE ("CUST_FIRST_NAME", "CUST_LAST_NAME") ENABLE
         )
      /
      CREATE TABLE  "CUST_SERVICES" 
         (     "CUST_ID" NUMBER NOT NULL ENABLE, 
           "SERVICE_ID" NUMBER NOT NULL ENABLE, 
            CONSTRAINT "CUST_SERVICES_PK" PRIMARY KEY ("CUST_ID", "SERVICE_ID") ENABLE
         )
      i want to choose multiple service to per customer , what's your ideas ?
        • 1. Re: multiple select value
          695721
          i am try to build tabular form
          select cs.SERVICE_ID,s.SERVICE_NAME, FLAG
          from CUST_SERVICES cs,SERVICES s
          where s.SERVICE_ID=cs.SERVICE_ID
          and cust_id =:p6_customer_id
          and make flag as check box to choose services fro the customer