DDL & DML COMMANDS 3

SQL> create table sales_order(s_order_no number(4) primary key,product_no number(4),client_no number(4),del_add varchar(20),del_date date,order_status varchar(20));

Table created.

SQL> desc sales_order;

Name	Null?	Type
S_ORDER_NO	NOT NULL	NUMBER(4)
PRODUCT_NO		NUMBER(4)
CLIENT_NO		NUMBER(4)
DEL_ADD		VARCHAR2(20)
DEL_DATE		DATE
ORDER_STATUS		VARCHAR2(20)

SQL> alter table sales_order add salesman_no number(4);

Table altered.

SQL>  desc sales_order;

Name	Null?	Type
S_ORDER_NO	NOT NULL	NUMBER(4)
PRODUCT_NO		NUMBER(4)
CLIENT_NO		NUMBER(4)
DEL_ADD		VARCHAR2(20)
DEL_DATE		DATE
ORDER_STATUS		VARCHAR2(20)
SALESMAN_NO		NUMBER(4)

SQL> insert into sales_order values (1,205,101,'mn street','22-oct-2010','delivered',260);

1 row created.

SQL>  insert into sales_order values (2,203,102,'ab street','28-nov-1989','pending',500);

1 row created.

SQL> insert into sales_order values (3,33,123,'qw street','24-jun-1991','delivered',500);

1 row created.

SQL> create table sales_order_cc(s_order_no number(4) references sales_order(s_order_no),product_no

number(5), qty_order number(5),product_rate number(10,2),primary key(s_order_no,product_no));

Table created.

SQL> desc sales_order_cc;

Name	Null?	Type
S_ORDER_NO	NOT NULL	NUMBER(4)
PRODUCT_NO	NOT NULL	NUMBER(5)
QTY_ORDER		NUMBER(5)
PRODUCT_RATE		NUMBER(10,2)

SQL> create table sales_order_tc(s_order_no number(4),product_no number(4),qty_order number(5),product_rate number(5,2),primary key(s_order_no ,product_no),foreign key(s_order_no) references sales_ord

er);

Table created.

SQL> desc sales_order_tc;

Name	Null?	Type
S_ORDER_NO	NOT NULL	NUMBER(4)
PRODUCT_NO	NOT NULL	NUMBER(5)
QTY_ORDER		NUMBER(5)
PRODUCT_RATE		NUMBER(10,2)

SQL> alter table sales_order add check(product_no >0);

Table altered.