Create table:
create table client_master(client_no varchar2(6),name varchar2(20) not null,address1 varchar2(30) not null,address2 varchar2(30) not null,city varchar2(15) not null,pincode number(8) not null, state varchar2(15) not null,bal_due number(10,2),primary key(client_no), CHECK(client_no like 'c%'));
Insert into table:
insert into client_master values(' c0001','ivan',bombay',4000054,'maharastr',15000);
insert into client_master values('c0002','varad','madras',780001,'tamilnadu',0);
insert into client_master values('c0003','pramod','bombay',400057,'maharastra',5000);
insert into client_master values('c00004','balli','bombay',400096,'maharastra',0);
create table client_master(client_no varchar2(6),name varchar2(20) not null,address1 varchar2(30) not null,address2 varchar2(30) not null,city varchar2(15) not null,pincode number(8) not null, state varchar2(15) not null,bal_due number(10,2),primary key(client_no), CHECK(client_no like 'c%'));
Insert into table:
insert into client_master values(' c0001','ivan',bombay',4000054,'maharastr',15000);
insert into client_master values('c0002','varad','madras',780001,'tamilnadu',0);
insert into client_master values('c0003','pramod','bombay',400057,'maharastra',5000);
insert into client_master values('c00004','balli','bombay',400096,'maharastra',0);
No comments:
Post a Comment