Thursday, 18 December 2014

How to create a table using primary key?

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);

No comments:

Post a Comment