Q:3
Insert data in the fields RollNo, Name, Sub1, Sub2, and Sub3. (At least 6 Records)
SQL> INSERT INTO STUDENT (ROLLNO, NAME, SUB1, SUB2, SUB3)
2 VALUES(&ROLLNO,'&NAME',&SUB1,&SUB2,&SUB3);
Enter value for rollno: 101
Enter value for name: AJMAL
Enter value for sub1: 75
Enter value for sub2: 83
Enter value for sub3: 76
old 2: VALUES(&ROLLNO,'&NAME',&SUB1,&SUB2,&SUB3)
new 2: VALUES(101,'AJMAL',75,83,76)
1 row created.
SQL> /
Enter value for rollno: 102
Enter value for name: JOHNSON
Enter value for sub1: 55
Enter value for sub2: 65
Enter value for sub3: 60
old 2: VALUES(&ROLLNO,'&NAME',&SUB1,&SUB2,&SUB3)
new 2: VALUES(102,'JOHNSON',55,65,60)
1 row created.
SQL> /
Enter value for rollno: 103
Enter value for name: AJAS
Enter value for sub1: 60
Enter value for sub2: 70
Enter value for sub3: 80
old 2: VALUES(&ROLLNO,'&NAME',&SUB1,&SUB2,&SUB3)
new 2: VALUES(103,'AJAS',60,70,80)
1 row created.
SQL> /
Enter value for rollno: 104
Enter value for name: ROGER
Enter value for sub1: 50
Enter value for sub2: 60
Enter value for sub3: 75
old 2: VALUES(&ROLLNO,'&NAME',&SUB1,&SUB2,&SUB3)
new 2: VALUES(104,'ROGER',50,60,75)
1 row created.
SQL> /
Enter value for rollno: 105
Enter value for name: BABU RAJ
Enter value for sub1: 90
Enter value for sub2: 95
Enter value for sub3: 98
old 2: VALUES(&ROLLNO,'&NAME',&SUB1,&SUB2,&SUB3)
new 2: VALUES(105,'BABU RAJ',90,95,98)
1 row created.
SQL> /
Enter value for rollno: 106
Enter value for name: SABU
Enter value for sub1: 75
Enter value for sub2: 80
Enter value for sub3: 82
old 2: VALUES(&ROLLNO,'&NAME',&SUB1,&SUB2,&SUB3)
new 2: VALUES(106,'SABU',75,80,82)
1 row created.
