(i)
Salesman table
Column name
|
Datatype
|
Size
|
Cus_no
|
Varchar2
|
6
|
Name
|
Varchar2
|
20
|
Address1
|
Varchar2
|
30
|
Address2
|
Varchar2
|
30
|
City
|
Varchar2
|
15
|
State
|
Varchar2
|
15
|
Pincode
|
Number
|
6
|
Bal_due
|
Number
|
10,2
|
Create Table:
create table sales_mans_t5 ( salesman_no varchar2(6) primary key check(salesman_no like 's%'), salesman_name varchar2(20) not null, address varchar2(20) not null, city varchar2(20), state varchar2(20), pincode number(6), sal_amt number(8,2) not null );
Insert Query:
insert into sales_mans_t5 values ('s00001','sayam singh','A/14 worli', 'Bombay','Mah','400002','3000'); insert into sales_mans_t5 values ('s00002','manish','65 nariman', 'Bombay','Mah','400001','3000'); insert into sales_mans_t5 values ('s00003','ravi','P-7 bandra', 'chennai','TN','632002','5000'); insert into sales_mans_t5 values ('s00004','ashish','A/5 jahu', 'bombay','Mah','400044','7000');
Select Query:
select * from sales_mans_t5;
Output:
Salesman_no
|
Salesman_name
|
Address
|
City
|
State
|
Pincode
|
Sal_amt
|
s00001
|
Sayam singh
|
A/14
worli
|
Bombay
|
Mah
|
400002
|
3000
|
s00002
|
Manish
|
65,nariman
|
Bombay
|
Mah
|
400001
|
3000
|
s00003
|
Ravi
|
P-7
Bandra
|
Chennai
|
TN
|
632002
|
5000
|
s00004
|
Ashish
|
A/5
Juhu
|
Bombay
|
Mah
|
400044
|
7000
|