KEMBAR78
SQL | PDF
Scribd
Upload
13 views1 page

SQL

The document contains SQL commands to create and manipulate two tables: WorkerSkill and student. It includes various INSERT statements to populate the WorkerSkill table with worker details and the student table with student information. Additionally, it defines a newstudent table with constraints on the fields, ensuring uniqueness and validity of the data entered.

Uploaded by

divya28032006
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd
13 views1 page

SQL

The document contains SQL commands to create and manipulate two tables: WorkerSkill and student. It includes various INSERT statements to populate the WorkerSkill table with worker details and the student table with student information. Additionally, it defines a newstudent table with constraints on the fields, ensuring uniqueness and validity of the data entered.

Uploaded by

divya28032006
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd
You are on page 1/ 1

create table WorkerSkill(Name varchar(25),Skill varchar(25),City

varchar(20),PhoneNumber varchar(20) );
INSERT INTO Workerskill VALUES('DICK JONES','SMITHY','TRICHY','91-0437-77651');
INSERT INTO Workerskill VALUES('JOHN PEARSON','COMBINE DRIVER','CHENNAI','91-0426-
98721');
INSERT INTO Workerskill VALUES('HELEN BRANDT','COMBINE DRIVER','MADURAI','91-0435-
33333');
INSERT INTO Workerskill VALUES('JOHN PEARSON','COMBINE DRIVER','CHENNAI','91-0453-
98765');
INSERT INTO Workerskill VALUES('JOHN PEARSON','SMITHY','CHENNAI','91-0345-34565');
INSERT INTO Workerskill VALUES('VICTORIA LYNN','SMITHY','SYDNEY','91-0234-98723');
INSERT INTO Workerskill VALUES('ADAH TALBOT','WORK','THANJAVUR','91-0652-66544');
INSERT INTO WorkerSkill VALUES('ELBERT LOWELL','DISCUS','DELHI','91-0433-90875');
INSERT INTO Workerskill VALUES('WILFRED LOWELL','WORK','SALEM','91-0213-98723');
INSERT INTO Workerskill VALUES('ANAND KUMAR','PROGRAM','ERODE','91-0441-98123');
INSERT INTO Workerskill VALUES('JACKSON','PROGRAM','HOSUR','91-0543-90873');
select * from Workerskill;
create table student ( REGNO VARCHAR2(20),
VARCHAR2(20),
DOB DATE,
MARK NUMBER(3));
desc student;
insert into student (regno) values('104');
insert into student (regno,name) values ('105','ganesh');
select * from student;
insert into student values('107','mathioli','12-dec-20',75) ;
select instr('sastra','a') from dual;
create table newstudent(
regno number(10) primary key,
name varchar(20) unique,
dob date not null,
mark number(3) default 0 check(mark > 0 and mark < 100));

You might also like