Record Insertion

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.