haydar baş ölmüş kepsli

sql> --
sql>
sql>
sql> create table product_order (
2 product_name varchar2(25),
3 salesperson varchar2(3),
4 order_date date,
5 quantity number(4,2)
6 );

table created.

sql>
sql> create table person (
2 person_code varchar2(3) primary key,
3 first_name varchar2(15),
4 last_name varchar2(20),
5 hire_date date
6 );

table created.

sql>
sql>
sql> insert into person values ('ca', 'chase', 'at', '01-feb-02');

1 row created.

sql> insert into person values ('ga', 'gary', 'talor', '15-feb-02');

1 row created.

sql> insert into person values ('bb', 'bob', 'bark', '28-feb-02');

1 row created.

sql> insert into person values ('lb', 'laren', 'baby', '01-mar-02');

1 row created.

sql> insert into person values ('ln', 'linda', 'norman','01-jun-03');

1 row created.

sql>
sql>
sql> insert into product_order values ('product 1', 'ca', '14-jul-03', 1);

1 row created.

sql> insert into product_order values ('product 2', 'bb', '14-jul-03', 75);

1 row created.

sql> insert into product_order values ('product 3', 'ga', '14-jul-03', 2);

1 row created.

sql> insert into product_order values ('product 4', 'ga', '15-jul-03', 8);

1 row created.

sql> insert into product_order values ('product 5', 'lb', '15-jul-03', 20);

1 row created.

sql> insert into product_order values ('product 6', 'ca', '16-jul-03', 5);

1 row created.

sql> insert into product_order values ('product 7', 'ca', '17-jul-03', 1);

1 row created.