1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
|
create table one (
firstname varchar2(255) not null,
lastname varchar2(255) not null,
age integer not null
);
create table two (
two_id integer not null primary key,
firstname varchar2(255) not null,
lastname varchar2(255) not null,
age integer not null
);
create table three (
firstname varchar2(255) not null,
lastname varchar2(255) not null,
age integer not null,
primary key ( firstname, lastname )
);
create view four as select * from one;
create view five as select * from two;
create view six as select * from three;
create table seven (
name varchar2(255) not null primary key,
age integer not null
);
|
