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