SQL: CREATE and INSERT Command Example

GTU DBMS Practical - 2

To study create and insert command.

1) CREATE a Job Table

				
					CREATE TABLE JOB(
job_id varchar2(18) primary ke,
job_title varchar2(30) unique,
min_sal number(7,2) not null,
max_sal number(7,2) not null);

Output

INSERT a Data into Job Table

				
					INSERT INTO job VALUES('web_fullstack','Full Stack Developer',9000,15000); 
INSERT INTO job VALUES('mobile_flutter','Flutter',8200,12000); 
INSERT INTO job VALUES('reactnative','React Native',4200,9000); 
INSERT INTO job VALUES('android','Android',6000,17000); 
INSERT INTO job VALUES('wordpress','Wordpress',1500,3000);

Output

2) CREATE a Employee Table

				
					CREATE TABLE employee( 
  emp_no number(3) primary key, 
  emp_name varchar2(30) not null, 
  emp_sal number(8,2), 
  emp_comm number(6,1), 
  dept_no number(3) not null);

Output

INSERT a Data into Employee Table

				
					INSERT INTO Employee VALUES(101,'Dhruvil',800,NULL,20); 
INSERT INTO Employee VALUES(102,'Mehul',1600,300,25); 
INSERT INTO Employee VALUES(103,'Ranjit',1100,0,20); 
INSERT INTO Employee VALUES(104,'Anjali',3000,null,15); 
INSERT INTO Employee VALUES(105,'Mohit',5000,50000,10); 
INSERT INTO Employee VALUES(106,'Jalpita',2450,24500,10); 
INSERT INTO Employee VALUES(107,'Chintan',2975,null,30);

Output

Output