Q:3
Insert data in the fields RollNo, Name, Batch, and Total. (at least 6 records)
SQL> INSERT INTO STUDENT VALUES(&ROLLNO,'&NAME','&BRANCH',&TOTAL);
Enter value for rollno: 201
Enter value for name: JOHN
Enter value for branch: COMMERCE
Enter value for total: 300
old 1: INSERT INTO STUDENT VALUES(&ROLLNO,'&NAME','&BRANCH',&TOTAL)
new 1: INSERT INTO STUDENT VALUES(201,'JOHN','COMMERCE',300)
1 row created.
SQL> /
Enter value for rollno: 202
Enter value for name: BABU
Enter value for branch: SCIENCE
Enter value for total: 200
old 1: INSERT INTO STUDENT VALUES(&ROLLNO,'&NAME','&BRANCH',&TOTAL)
new 1: INSERT INTO STUDENT VALUES(202,'BABU','SCIENCE',200)
1 row created.
SQL> /
Enter value for rollno: 203
Enter value for name: GEORGE
Enter value for branch: COMPUTER
Enter value for total: 500
old 1: INSERT INTO STUDENT VALUES(&ROLLNO,'&NAME','&BRANCH',&TOTAL)
new 1: INSERT INTO STUDENT VALUES(203,'GEORGE','COMPUTER',500)
INSERT INTO STUDENT VALUES(203,'GEORGE','COMPUTER',500)
*
ERROR at line 1:
ORA-02290: check constraint (SCOTT.SYS_C003040) violated
SQL> /
Enter value for rollno: 203
Enter value for name: GEORGE
Enter value for branch: HUMANITIES
Enter value for total: 500
old 1: INSERT INTO STUDENT VALUES(&ROLLNO,'&NAME','&BRANCH',&TOTAL)
new 1: INSERT INTO STUDENT VALUES(203,'GEORGE','HUMANITIES',500)
1 row created.
SQL> /
Enter value for rollno: 204
Enter value for name: JIBIN
Enter value for branch: COMMERCE
Enter value for total: 400
old 1: INSERT INTO STUDENT VALUES(&ROLLNO,'&NAME','&BRANCH',&TOTAL)
new 1: INSERT INTO STUDENT VALUES(204,'JIBIN','COMMERCE',400)
1 row created.
SQL> /
Enter value for rollno: 205
Enter value for name: VARGHESE
Enter value for branch: SCIENCE
Enter value for total: 250
old 1: INSERT INTO STUDENT VALUES(&ROLLNO,'&NAME','&BRANCH',&TOTAL)
new 1: INSERT INTO STUDENT VALUES(205,'VARGHESE','SCIENCE',250)
1 row created.
SQL> /
Enter value for rollno: 206
Enter value for name: SOMAN
Enter value for branch: HUMANITIES
Enter value for total: 420
old 1: INSERT INTO STUDENT VALUES(&ROLLNO,'&NAME','&BRANCH',&TOTAL)
new 1: INSERT INTO STUDENT VALUES(206,'SOMAN','HUMANITIES',420)
1 row created.
