Re: Inserting into types on Oracle8

From: Dan Townsend <townsend_at_ebmud.com>
Date: 1997/07/25
Message-ID: <33D906A8.733D@ebmud.com>#1/1

Mike,
Use the constructor for type x:

insert into y values (x(3,'three'), 'dee');

Then check my posted question about CREATE TYPE BODY syntax and let me know if you can help. Thanks!

Mike wrote:

> Hi, a quick RTFM request having created a type:
> create type x (a number, b varchar2(10));
> create a table containing the type:
> create table y (c x, d varchar2(10));
> How do you insert values into column c in the table y?

 +-----------------------------------------------------
| Dan Townsend, Supervising Database Architect

| EBMUD Enterprise Object Designer
| mailto:townsend_at_ebmud.com

+-----------------------------------------------------

Received on Fri Jul 25 1997 - 00:00:00 CDT