Home » SQL & PL/SQL » SQL & PL/SQL » Re: how to insert into nested table?
Re: how to insert into nested table? [message #36450] Wed, 28 November 2001 16:00
Peter
Messages: 62
Registered: August 2000
Member
I have the same problem to day. You need to insert some initial value in the nested table before you do a query on it.
For you first insert you need to insert values for
NODE_ATTR_VALUE
DISCOUNT NUMBER.

you will need to
INSERT INTO SERVICE(ID,START_TIME,END_TIME)
VALUES(1,SYSDATE,SYSDATE
DISCOUNT_NT(DISCOUNT_TY('AA',0.8)));

-- You may need switch around :
DISCOUNT_dy(DISCOUNT_nt(

Email me at : calbert@mailcity.com

----------------------------------------------------------------------
Previous Topic: Delete Database ?
Next Topic: Re: Cursors in Procedures
Goto Forum:
  


Current Time: Sat Mar 28 19:56:21 CDT 2020