各位大哥大姐,高手们帮帮小弟把,在表1和表2中分别插入2行数据,请知道的大侠把代码写出来把,谢谢了!!
--表1:
Create or replace type Event_Type as object
(EventId varchar2(250),
Description varchar2 (250),
EventDate date,
Location varchar2(100));Create or replace type EventNestedtable as table of Event_Type;--表2:
Create table CateringCustomer
(CustomerNo varchar2 (20),
Name varchar2(25),
Address varchar2 (100),
Events eventNestedtable)
nested table Events store as EventNestedtable_tab;
--表1:
Create or replace type Event_Type as object
(EventId varchar2(250),
Description varchar2 (250),
EventDate date,
Location varchar2(100));Create or replace type EventNestedtable as table of Event_Type;--表2:
Create table CateringCustomer
(CustomerNo varchar2 (20),
Name varchar2(25),
Address varchar2 (100),
Events eventNestedtable)
nested table Events store as EventNestedtable_tab;
解决方案 »
- 这样的插入竟然会有两条数据
- Oracle一个特别特别奇怪的问题
- oracle安装问题
- oracle创建用户时为什么用了两个表空间,请帮忙解释一下,3qU
- ORA-01017: invalid username/password; logon denied 错误
- Looking for Oracle developer - RMB 20K/month
- oracle存储过程能否返回本身的名字?
- 送分问菜鸟问题,在线等!
- 刚刚接触unix下的oracle... 几个问题,
- sql语句的问题,高手们指点一下。
- 【PL/SQL疑难杂症】关于PL/SQL语句问题,请求诊病????
- 学习oracle一定要安装oracle吗?
http://topic.csdn.net/u/20090217/04/b489994d-3458-4f52-a0e9-78b841ff44a5.html
做了回答