This discussion is archived
1 Reply Latest reply: Nov 18, 2012 4:43 AM by 695721 RSS

multiple select value

695721 Newbie
Currently Being Moderated
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 Newbie
    Currently Being Moderated
    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

Legend

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