SQL> create table emply(empcode varchar2(4) primary key, empname varchar2(20) not null,
2 address varchar2(30), age number(2) not null, deptcode varchar2(4) not null);
Table created.
SQL> insert into emply values('&empcode', '&empname', '&address', &age, '&deptcode');
Enter value for empcode: E101
Enter value for empname: Anjaly
Enter value for address: Anjaly Nivas, Thiruvalla
Enter value for age: 25
Enter value for deptcode: D302
old 1: insert into emply values('&empcode', '&empname', '&address', &age, '&deptcode')
new 1: insert into emply values('E101', 'Anjaly', 'Anjaly Nivas, Thiruvalla', 25, 'D302')
1 row created.
SQL> insert into emply values('&empcode', '&empname', '&address', &age, '&deptcode');
Enter value for empcode: E102
Enter value for empname: Bobby
Enter value for address: Alapuzha
Enter value for age: 28
Enter value for deptcode: D305
old 1: insert into emply values('&empcode', '&empname', '&address', &age, '&deptcode')
new 1: insert into emply values('E102', 'Bobby', 'Alapuzha', 28, 'D305')
1 row created.
SQL> /
Enter value for empcode: E103
Enter value for empname: Aravind
Enter value for address: Chennai
Enter value for age: 31
Enter value for deptcode: D305
old 1: insert into emply values('&empcode', '&empname', '&address', &age, '&deptcode')
new 1: insert into emply values('E103', 'Aravind', 'Chennai', 31, 'D305')
1 row created.
SQL> /
Enter value for empcode: E104
Enter value for empname: Lakshmi
Enter value for address: Mannar
Enter value for age: 55
Enter value for deptcode: D707
old 1: insert into emply values('&empcode', '&empname', '&address', &age, '&deptcode')
new 1: insert into emply values('E104', 'Lakshmi', 'Mannar', 55, 'D707')
1 row created.
SQL> /
Enter value for empcode: E105
Enter value for empname: Daisy
Enter value for address: Chaithram, Angamaly
Enter value for age: 35
Enter value for deptcode: D707
old 1: insert into emply values('&empcode', '&empname', '&address', &age, '&deptcode')
new 1: insert into emply values('E105', 'Daisy', 'Chaithram, Angamaly', 35, 'D707')
1 row created.
SQL> /
Enter value for empcode: E106
Enter value for empname: Esha
Enter value for address: Mumbai
Enter value for age: 23
Enter value for deptcode: D707
old 1: insert into emply values('&empcode', '&empname', '&address', &age, '&deptcode')
new 1: insert into emply values('E106', 'Esha', 'Mumbai', 23, 'D707')
1 row created.
SQL> /
Enter value for empcode: E107
Enter value for empname: George
Enter value for address: Pala
Enter value for age: 45
Enter value for deptcode: D909
old 1: insert into emply values('&empcode', '&empname', '&address', &age, '&deptcode')
new 1: insert into emply values('E107', 'George', 'Pala', 45, 'D909')
1 row created.
SQL> /
Enter value for empcode: E108
Enter value for empname: Prakash
Enter value for address: Vennikulam
Enter value for age: 36
Enter value for deptcode: D110
old 1: insert into emply values('&empcode', '&empname', '&address', &age, '&deptcode')
new 1: insert into emply values('E108', 'Prakash', 'Vennikulam', 36, 'D110')
1 row created.
SQL> /
Enter value for empcode: E109
Enter value for empname: Madhavan
Enter value for address: Mynakum, Kottayam
Enter value for age: 46
Enter value for deptcode: D202
old 1: insert into emply values('&empcode', '&empname', '&address', &age, '&deptcode')
new 1: insert into emply values('E109', 'Madhavan', 'Mynakum, Kottayam', 46, 'D202')
1 row created.
SQL> /
Enter value for empcode: E110
Enter value for empname: Anugraha
Enter value for address: Aparna, Angamaly
Enter value for age: 47
Enter value for deptcode: D301
old 1: insert into emply values('&empcode', '&empname', '&address', &age, '&deptcode')
new 1: insert into emply values('E110', 'Anugraha', 'Aparna, Angamaly', 47, 'D301')
1 row created.
SQL> /
Enter value for empcode: E111
Enter value for empname: Deva
Enter value for address: Trichy
Enter value for age: 38
Enter value for deptcode: D301
old 1: insert into emply values('&empcode', '&empname', '&address', &age, '&deptcode')
new 1: insert into emply values('E111', 'Deva', 'Trichy', 38, 'D301')
1 row created.
SQL> /
Enter value for empcode: E112
Enter value for empname: Saju
Enter value for address: Dhanya, Ernakulam
Enter value for age: 27
Enter value for deptcode: D202
old 1: insert into emply values('&empcode', '&empname', '&address', &age, '&deptcode')
new 1: insert into emply values('E112', 'Saju', 'Dhanya, Ernakulam', 27, 'D202')
1 row created.
SQL> /
Enter value for empcode: E113
Enter value for empname: Priyesh
Enter value for address: Priya Nivas, Kottayam
Enter value for age: 26
Enter value for deptcode: D302
old 1: insert into emply values('&empcode', '&empname', '&address', &age, '&deptcode')
new 1: insert into emply values('E113', 'Priyesh', 'Priya Nivas, Kottayam', 26, 'D302')
1 row created.
SQL> select * from emply;
EMPC EMPNAME ADDRESS AGE DEPT
---- -------------------- ------------------------------ ---------- ----
E101 Anjaly Anjaly Nivas, Thiruvalla 25 D302
E102 Bobby Alapuzha 28 D305
E103 Aravind Chennai 31 D305
E104 Lakshmi Mannar 55 D707
E105 Daisy Chaithram, Angamaly 35 D707
E106 Esha Mumbai 23 D707
E107 George Pala 45 D909
E108 Prakash Vennikulam 36 D110
E109 Madhavan Mynakum, Kottayam 46 D202
E110 Anugraha Aparna, Angamaly 47 D301
E111 Deva Trichy 38 D301
EMPC EMPNAME ADDRESS AGE DEPT
---- -------------------- ------------------------------ ---------- ----
E112 Saju Dhanya, Ernakulam 27 D202
E113 Priyesh Priya Nivas, Kottayam 26 D302
13 rows selected.
|
