FORMAT COMMAND:
SQL> column ADDS Format a10;
SQL> select * from student20903;
ROLLNO FNAME LNAME ADDS DOB MOBNO
---------- ---------- ---------- ------------------------- --------- ----------
201 Salekin ansari vashi 01-JAN-88 9920202021
202 Rohan patil Thane 29-FEB-92 9967202021
203 Gayas choudhari airoli 19-FEB-88 8067201121
204 Manju choudhari airoli 11-JAN-86 9029794139
205 Manoj Gupata Nerul 01-JAN-82 8088202321
UPDATE TABLE:
SQL> Update stdnt_marks set sem1=50
WHERE rollno='203';
1 row updated.
SQL> select * from stdnt_marks;
ROLLNO SEAT_NO SEM1 SEM2
---------- ----- ---------- -------------------------
201 AB01 56 76
202 AB02 86 66
203 AB03 50 56
204 AB04 86 86