Hi,
I suggest you to not to insert multiple value into single row of same column.
because it create problem in future when you use this table.
You can insert like following eg.
insert into tablename values ('A103,A104',3,'TwoSeater',Booked)
I again suggest you to keep or insert record like this into your table.
RollNumber RoomNumber RoomType Status
-------------------------------------------------------------
A101 1 Single Booked
-------------------------------------------------------------
A102 2 Single Booked
-------------------------------------------------------------
A103 3 TwoSeater Booked
-------------------------------------------------------------
A104 3 TwoSeater Booked
-------------------------------------------------------------
A105 4 TwoSeater Available
-------------------------------------------------------------
A106 3 FourSeater Available
-------------------------------------------------------------
A107 4 FourSeater Available
-------------------------------------------------------------
This one easy and helpful way.
Ranjeet waje