Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> object problem

object problem

From: Francis Wong <wongfrancis_at_home.com>
Date: 2000/06/22
Message-ID: <0Rv45.17416$7I1.351296@news1.rdc2.on.home.com>#1/1

I define a object type like the following:

create type address_objtyp as object (

    addr1       varchar2(20),
    addr2       varchar2(20),

...
...

)

and then define a table somewhat like this:

create table customer(

    cust_name varchar2(30),
....
....

    address address_objtyp,
....
....

)

What is the command syntax try to set the the columns address.addr1 and address.addr2 not null? Received on Thu Jun 22 2000 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US