SQL> UPDATE students 2 SET hometown = 'Vorhees' 3 WHERE studentid = '1113'; 1 row updated. SQL> select * from students; STUD FIRST M LAST YE MAJO NUMCREDITSEARNED GPA HOMETOWN BALANCEDUE ---- --------------- - --------------- -- ---- ---------------- ---------- -------------------- ---------- 1011 Ason J Kidd So MGMT 40 3.1 Oakland 0 1093 Chris T Webber So CSC 45 3.51 Haddonfield 2500 1111 Charles D Barkley Fr HIS 22 3 Pennsauken 0 1113 Kenny T Anderson So MGMT 54 2.85 Vorhees 1000 1115 Shaq O O'Neal Jr MKTG 94 3.82 Vorhees 0 1116 Allen X Iverson Jr BIO 81 2.87 Maple Shade 3500 1117 Grant P Hill Sr CSC 107 3.87 Pennsauken 0 1119 Marcus S Camby So CHEM 48 3.21 Pennsauken 50 1123 Shawn W Bradley Fr CSC 27 2.12 Palmyra 1500 1212 Kobe J Bryant So BIO 31 2.67 Lower Merion 125 1818 Kevin G Garnett Fr BIO 12 1.9 Chicago 0 2121 Keith V Van Horn Sr MGMT 91 2.98 Cherry Hill 100 2222 Larry R Hughes So BIO 13 3.1 Philadelphia 0 3131 Shane D Battier Fr CHEM 15 3.85 Vorhees 0 4141 Glenn B Robinson Jr HIS 70 2.5 Philadelphia 120 5151 Baron U Davis So BIO 32 2.99 Westwood 0 5555 Penny A Hardaway Fr CSC 12 2.31 Cherry Hill 0 6161 Michael S Jordan Sr MKTG 110 3.65 Wilmington 0 7070 Tim D Duncan Sr HIS 99 3.87 San Antonio 10 7171 Paul P Pierce So CHEM 35 3.1 Boston 100 20 rows selected. SQL> UPDATE students 2 SET hometown = 'Los Angeles', balancedue = '1000' 3 WHERE studentid = '1212'; 1 row updated. SQL> select * from students; STUD FIRST M LAST YE MAJO NUMCREDITSEARNED GPA HOMETOWN BALANCEDUE ---- --------------- - --------------- -- ---- ---------------- ---------- -------------------- ---------- 1011 Ason J Kidd So MGMT 40 3.1 Oakland 0 1093 Chris T Webber So CSC 45 3.51 Haddonfield 2500 1111 Charles D Barkley Fr HIS 22 3 Pennsauken 0 1113 Kenny T Anderson So MGMT 54 2.85 Vorhees 1000 1115 Shaq O O'Neal Jr MKTG 94 3.82 Vorhees 0 1116 Allen X Iverson Jr BIO 81 2.87 Maple Shade 3500 1117 Grant P Hill Sr CSC 107 3.87 Pennsauken 0 1119 Marcus S Camby So CHEM 48 3.21 Pennsauken 50 1123 Shawn W Bradley Fr CSC 27 2.12 Palmyra 1500 1212 Kobe J Bryant So BIO 31 2.67 Los Angeles 1000 1818 Kevin G Garnett Fr BIO 12 1.9 Chicago 0 2121 Keith V Van Horn Sr MGMT 91 2.98 Cherry Hill 100 2222 Larry R Hughes So BIO 13 3.1 Philadelphia 0 3131 Shane D Battier Fr CHEM 15 3.85 Vorhees 0 4141 Glenn B Robinson Jr HIS 70 2.5 Philadelphia 120 5151 Baron U Davis So BIO 32 2.99 Westwood 0 5555 Penny A Hardaway Fr CSC 12 2.31 Cherry Hill 0 6161 Michael S Jordan Sr MKTG 110 3.65 Wilmington 0 7070 Tim D Duncan Sr HIS 99 3.87 San Antonio 10 7171 Paul P Pierce So CHEM 35 3.1 Boston 100 20 rows selected. SQL> UPDATE students 2 SET balancedue = balancedue + 500 3 WHERE studentid = '1212'; 1 row updated. SQL> select * from students; STUD FIRST M LAST YE MAJO NUMCREDITSEARNED GPA HOMETOWN BALANCEDUE ---- --------------- - --------------- -- ---- ---------------- ---------- -------------------- ---------- 1011 Ason J Kidd So MGMT 40 3.1 Oakland 0 1093 Chris T Webber So CSC 45 3.51 Haddonfield 2500 1111 Charles D Barkley Fr HIS 22 3 Pennsauken 0 1113 Kenny T Anderson So MGMT 54 2.85 Vorhees 1000 1115 Shaq O O'Neal Jr MKTG 94 3.82 Vorhees 0 1116 Allen X Iverson Jr BIO 81 2.87 Maple Shade 3500 1117 Grant P Hill Sr CSC 107 3.87 Pennsauken 0 1119 Marcus S Camby So CHEM 48 3.21 Pennsauken 50 1123 Shawn W Bradley Fr CSC 27 2.12 Palmyra 1500 1212 Kobe J Bryant So BIO 31 2.67 Los Angeles 1500 1818 Kevin G Garnett Fr BIO 12 1.9 Chicago 0 2121 Keith V Van Horn Sr MGMT 91 2.98 Cherry Hill 100 2222 Larry R Hughes So BIO 13 3.1 Philadelphia 0 3131 Shane D Battier Fr CHEM 15 3.85 Vorhees 0 4141 Glenn B Robinson Jr HIS 70 2.5 Philadelphia 120 5151 Baron U Davis So BIO 32 2.99 Westwood 0 5555 Penny A Hardaway Fr CSC 12 2.31 Cherry Hill 0 6161 Michael S Jordan Sr MKTG 110 3.65 Wilmington 0 7070 Tim D Duncan Sr HIS 99 3.87 San Antonio 10 7171 Paul P Pierce So CHEM 35 3.1 Boston 100 20 rows selected. SQL> UPDATE students 2 SET year = 'Jr' 3 WHERE studentid = '2121'; 1 row updated. SQL> select * from students; STUD FIRST M LAST YE MAJO NUMCREDITSEARNED GPA HOMETOWN BALANCEDUE ---- --------------- - --------------- -- ---- ---------------- ---------- -------------------- ---------- 1011 Ason J Kidd So MGMT 40 3.1 Oakland 0 1093 Chris T Webber So CSC 45 3.51 Haddonfield 2500 1111 Charles D Barkley Fr HIS 22 3 Pennsauken 0 1113 Kenny T Anderson So MGMT 54 2.85 Vorhees 1000 1115 Shaq O O'Neal Jr MKTG 94 3.82 Vorhees 0 1116 Allen X Iverson Jr BIO 81 2.87 Maple Shade 3500 1117 Grant P Hill Sr CSC 107 3.87 Pennsauken 0 1119 Marcus S Camby So CHEM 48 3.21 Pennsauken 50 1123 Shawn W Bradley Fr CSC 27 2.12 Palmyra 1500 1212 Kobe J Bryant So BIO 31 2.67 Los Angeles 1500 1818 Kevin G Garnett Fr BIO 12 1.9 Chicago 0 2121 Keith V Van Horn Jr MGMT 91 2.98 Cherry Hill 100 2222 Larry R Hughes So BIO 13 3.1 Philadelphia 0 3131 Shane D Battier Fr CHEM 15 3.85 Vorhees 0 4141 Glenn B Robinson Jr HIS 70 2.5 Philadelphia 120 5151 Baron U Davis So BIO 32 2.99 Westwood 0 5555 Penny A Hardaway Fr CSC 12 2.31 Cherry Hill 0 6161 Michael S Jordan Sr MKTG 110 3.65 Wilmington 0 7070 Tim D Duncan Sr HIS 99 3.87 San Antonio 10 7171 Paul P Pierce So CHEM 35 3.1 Boston 100 20 rows selected. SQL> UPDATE students 2 SET year = 'Sr' 3 WHERE numcreditsearned >= 90; 5 rows updated. SQL> select * from students; STUD FIRST M LAST YE MAJO NUMCREDITSEARNED GPA HOMETOWN BALANCEDUE ---- --------------- - --------------- -- ---- ---------------- ---------- -------------------- ---------- 1011 Ason J Kidd So MGMT 40 3.1 Oakland 0 1093 Chris T Webber So CSC 45 3.51 Haddonfield 2500 1111 Charles D Barkley Fr HIS 22 3 Pennsauken 0 1113 Kenny T Anderson So MGMT 54 2.85 Vorhees 1000 1115 Shaq O O'Neal Sr MKTG 94 3.82 Vorhees 0 1116 Allen X Iverson Jr BIO 81 2.87 Maple Shade 3500 1117 Grant P Hill Sr CSC 107 3.87 Pennsauken 0 1119 Marcus S Camby So CHEM 48 3.21 Pennsauken 50 1123 Shawn W Bradley Fr CSC 27 2.12 Palmyra 1500 1212 Kobe J Bryant So BIO 31 2.67 Los Angeles 1500 1818 Kevin G Garnett Fr BIO 12 1.9 Chicago 0 2121 Keith V Van Horn Sr MGMT 91 2.98 Cherry Hill 100 2222 Larry R Hughes So BIO 13 3.1 Philadelphia 0 3131 Shane D Battier Fr CHEM 15 3.85 Vorhees 0 4141 Glenn B Robinson Jr HIS 70 2.5 Philadelphia 120 5151 Baron U Davis So BIO 32 2.99 Westwood 0 5555 Penny A Hardaway Fr CSC 12 2.31 Cherry Hill 0 6161 Michael S Jordan Sr MKTG 110 3.65 Wilmington 0 7070 Tim D Duncan Sr HIS 99 3.87 San Antonio 10 7171 Paul P Pierce So CHEM 35 3.1 Boston 100 20 rows selected. SQL> commit 2 ; Commit complete. SQL> spool off