SQL> CREATE TABLE empss(emp_name varchar(15) NOT NULL,emp_ssn int primary
key,salary int,emp_DOB int,emp_address varchar(10),gender varchar(10));
Table created.
SQL> INSERT INTO emp
values('&emp_name',&emp_ssn,&salary,'&emp_DOB','&emp_address','&gender');
Enter value for emp_name:
Enter value for emp_ssn:
Enter value for salary:
Enter value for emp_dob:
Enter value for emp_address:
Enter value for gender:
old 1: INSERT INTO emp
values('&emp_name',&emp_ssn,&salary,'&emp_DOB','&emp_address','&gender')
new 1: INSERT INTO emp values('',,,'','','')
INSERT INTO emp values('',,,'','','')
*
ERROR at line 1:
ORA-00936: missing expression
SQL> INSERT INTO empss
values('&emp_name',&emp_ssn,&salary,'&emp_DOB','&emp_address','&gender');
Enter value for emp_name: srivalli
Enter value for emp_ssn: 1234
Enter value for salary: 20000
Enter value for emp_dob: 2007
Enter value for emp_address: ongole
Enter value for gender: female
old 1: INSERT INTO empss
values('&emp_name',&emp_ssn,&salary,'&emp_DOB','&emp_address','&gender')
new 1: INSERT INTO empss values('srivalli',1234,20000,'2007','ongole','female')
1 row created.
SQL> /
Enter value for emp_name: mounika
Enter value for emp_ssn: vizag
Enter value for salary: 12000
Enter value for emp_dob: 2006
Enter value for emp_address: tirupathi
Enter value for gender: female
old 1: INSERT INTO empss
values('&emp_name',&emp_ssn,&salary,'&emp_DOB','&emp_address','&gender')
new 1: INSERT INTO empss
values('mounika',vizag,12000,'2006','tirupathi','female')
INSERT INTO empss values('mounika',vizag,12000,'2006','tirupathi','female')
*
ERROR at line 1:
ORA-00984: column not allowed here
SQL> /
Enter value for emp_name: radha
Enter value for emp_ssn: rega
Enter value for salary: 120000
Enter value for emp_dob: 2003
Enter value for emp_address:
Enter value for gender:
old 1: INSERT INTO empss
values('&emp_name',&emp_ssn,&salary,'&emp_DOB','&emp_address','&gender')
new 1: INSERT INTO empss values('radha',rega,120000,'2003','','')
INSERT INTO empss values('radha',rega,120000,'2003','','')
*
ERROR at line 1:
ORA-00984: column not allowed here
SQL> /
Enter value for emp_name: laxmi
Enter value for emp_ssn: 1235
Enter value for salary: 13000
Enter value for emp_dob: 1967
Enter value for emp_address: srikakulam
Enter value for gender: female
old 1: INSERT INTO empss
values('&emp_name',&emp_ssn,&salary,'&emp_DOB','&emp_address','&gender')
new 1: INSERT INTO empss values('laxmi',1235,13000,'1967','srikakulam','female')
1 row created.
SQL> /
Enter value for emp_name: laxman
Enter value for emp_ssn: 1256
Enter value for salary: 12677
Enter value for emp_dob: 2009
Enter value for emp_address: krishna
Enter value for gender: male
old 1: INSERT INTO empss
values('&emp_name',&emp_ssn,&salary,'&emp_DOB','&emp_address','&gender')
new 1: INSERT INTO empss values('laxman',1256,12677,'2009','krishna','male')
1 row created.
SQL> /
Enter value for emp_name: teja
Enter value for emp_ssn: 1268
Enter value for salary: 30000
Enter value for emp_dob: 1976
Enter value for emp_address: eluru
Enter value for gender: female
old 1: INSERT INTO empss
values('&emp_name',&emp_ssn,&salary,'&emp_DOB','&emp_address','&gender')
new 1: INSERT INTO empss values('teja',1268,30000,'1976','eluru','female')
1 row created.
SQL> /
Enter value for emp_name: ram
Enter value for emp_ssn: 1356
Enter value for salary: 540000
Enter value for emp_dob: 2005
Enter value for emp_address: kakinada
Enter value for gender: male
old 1: INSERT INTO empss
values('&emp_name',&emp_ssn,&salary,'&emp_DOB','&emp_address','&gender')
new 1: INSERT INTO empss values('ram',1356,540000,'2005','kakinada','male')
1 row created.
SQL> /
Enter value for emp_name: koushik
Enter value for emp_ssn: 1675
Enter value for salary: 38000
Enter value for emp_dob: 2001
Enter value for emp_address: peta
Enter value for gender: male
old 1: INSERT INTO empss
values('&emp_name',&emp_ssn,&salary,'&emp_DOB','&emp_address','&gender')
new 1: INSERT INTO empss values('koushik',1675,38000,'2001','peta','male')
1 row created.
SQL> /
Enter value for emp_name: tej
Enter value for emp_ssn: 3546
Enter value for salary: 23000
Enter value for emp_dob: 1998
Enter value for emp_address: rajam
Enter value for gender: male
old 1: INSERT INTO empss
values('&emp_name',&emp_ssn,&salary,'&emp_DOB','&emp_address','&gender')
new 1: INSERT INTO empss values('tej',3546,23000,'1998','rajam','male')
1 row created.
SQL> /
Enter value for emp_name: mouni
Enter value for emp_ssn: 2435
Enter value for salary: 30000
Enter value for emp_dob: 2002
Enter value for emp_address: godavari
Enter value for gender: female
old 1: INSERT INTO empss
values('&emp_name',&emp_ssn,&salary,'&emp_DOB','&emp_address','&gender')
new 1: INSERT INTO empss values('mouni',2435,30000,'2002','godavari','female')
1 row created.
SQL> SELECT * FROM EMPSS;
EMP_NAME EMP_SSN SALARY EMP_DOB EMP_ADDRES GENDER
--------------- ---------- ---------- ---------- ---------- ----------
srivalli 1234 20000 2007 ongole female
laxmi 1235 13000 1967 srikakulam female
laxman 1256 12677 2009 krishna male
teja 1268 30000 1976 eluru female
ram 1356 540000 2005 kakinada male
koushik 1675 38000 2001 peta male
tej 3546 23000 1998 rajam male
mouni 2435 30000 2002 godavari female
8 rows selected.
SQL> CREATE TABLE project(pname varchar(20),pno int primary key,ploc varchar(20));
Table created.
SQL> INSERT INTO project values(pname varchar(20),pno int primary key,
