Schwinn Sid User Manual download pdf (Page 22)

Objekttypen und -tabellen

CREATE OR REPLACE TYPE address_t AS OBJECT

(street varchar2(30),

city varchar2(30),

state varchar2(2),

zip varchar2(10))

/

CREATE OR REPLACE TYPE person_t AS OBJECT

(last_name varchar2(30),

birthdate date,

birthdate date,

address address_t) NOT FINAL

/

CREATE TABLE person OF person_t

/

INSERT INTO person VALUES (person_t(...,...));

1 2 ... 17 18 19 20 21 22 23 24 25 26 27 ... 48 49

Comments to this Manuals

No comments