Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2011
    Posts
    47

    Unanswered: How to solve this problem ?

    I have a table which has a attribute which of type varray..c below

    Code:
    create or replace type medicines_51 as object (med_id number ,
     med_name varchar2(50), manf_date date);
    Code:
    create or replace type medicine_arr_51 as varray(40) of medicines_51
    Code:
    create table med_store_51 (loc varchar2(50), store_size number , 
    employees number, med_items medicine_arr_51 )
    i have inserted a tuple
    Code:
    insert into med_store_51 values('BELMONT',1000,10,
    medicine_arr_51( 
    medicines_51  ( 11111,'STOPACHE',SYSDATE)
    )
    )
    now the question to be solved is :
    Q) Update the MED_STORE table and add more medicines to the Belmont store.

  2. #2
    Join Date
    Jun 2003
    Location
    West Palm Beach, FL
    Posts
    2,713
    Quote Originally Posted by navedjobs View Post
    I have a table which has a attribute which of type varray..c below
    . . . . .
    now the question to be solved is :
    Q) Update the MED_STORE table and add more medicines to the Belmont store.
    This question is varrays 101.
    Perhaps if you do not know how to use Varray's, DONT use them!
    The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

  3. #3
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •