Insertion of Records

Q:3
Insert data in all the fields. (at least 7 records)


SQL> INSERT INTO DEPOSIT VALUES(&ACCNO,'&NAME','&BRANCH',&AMOUNT);
Enter value for accno: 1001
Enter value for name: SYAM KUMAR
Enter value for branch: CALICUT
Enter value for amount: 55000
old   1: INSERT INTO DEPOSIT VALUES(&ACCNO,'&NAME','&BRANCH',&AMOUNT)
new   1: INSERT INTO DEPOSIT VALUES(1001,'SYAM KUMAR','CALICUT',55000)

1 row created.

SQL> /
Enter value for accno: 1002
Enter value for name: RAM KUMAR
Enter value for branch: COCHIN
Enter value for amount: 25000
old   1: INSERT INTO DEPOSIT VALUES(&ACCNO,'&NAME','&BRANCH',&AMOUNT)
new   1: INSERT INTO DEPOSIT VALUES(1002,'RAM KUMAR','COCHIN',25000)

1 row created.

SQL> /
Enter value for accno: 1003
Enter value for name: KRISHNA KUMAR
Enter value for branch: TRICHUR
Enter value for amount: 45000
old   1: INSERT INTO DEPOSIT VALUES(&ACCNO,'&NAME','&BRANCH',&AMOUNT)
new   1: INSERT INTO DEPOSIT VALUES(1003,'KRISHNA KUMAR','TRICHUR',45000)

1 row created.


SQL> /
Enter value for accno: 1004
Enter value for name: MOHAN KUMAR
Enter value for branch: COCHIN
Enter value for amount: 5000
old   1: INSERT INTO DEPOSIT VALUES(&ACCNO,'&NAME','&BRANCH',&AMOUNT)
new   1: INSERT INTO DEPOSIT VALUES(1004,'MOHAN KUMAR','COCHIN',5000)

1 row created.

SQL> /
Enter value for accno: 1005
Enter value for name: ANIL KUMAR
Enter value for branch: TRICHUR
Enter value for amount: 35000
old   1: INSERT INTO DEPOSIT VALUES(&ACCNO,'&NAME','&BRANCH',&AMOUNT)
new   1: INSERT INTO DEPOSIT VALUES(1005,'ANIL KUMAR','TRICHUR',35000)

1 row created.

SQL> /
Enter value for accno: 1006
Enter value for name: DEVA KUMAR
Enter value for branch: CALICUT
Enter value for amount: 60000
old   1: INSERT INTO DEPOSIT VALUES(&ACCNO,'&NAME','&BRANCH',&AMOUNT)
new   1: INSERT INTO DEPOSIT VALUES(1006,'DEVA KUMAR','CALICUT',60000)

1 row created.


SQL> /
Enter value for accno: 1007
Enter value for name: ASHOK KUMAR
Enter value for branch: CALICUT
Enter value for amount: 45000
old   1: INSERT INTO DEPOSIT VALUES(&ACCNO,'&NAME','&BRANCH',&AMOUNT)
new   1: INSERT INTO DEPOSIT VALUES(1007,'ASHOK KUMAR','CALICUT',45000)

1 row created.