| 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
----------------------------------------------------------------------
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
