oracle10g - how to SAVE many values in one field/column of one row in oracle database? -

i want keep track of individual's credit card transactions(the amount, in essence). instead of having new entry made in database each transaction, there way can save transactions of 1 person on single row? i.e. , if person makes purchases of rs.1500, rs. 2600 , rs. 3200 @ different instances, want table entry this:

a : 1500, 2600, 3200 

also, there way can keep number of entries? meaning, 1 new entry added, 1 oldest entry should deleted. i'm using oracle 10g. please me out. thank you.

can you? well, define column varchar2 or clob , write comma-separated list of values column. mean have write code parse data every time selected it. , write code things removing or modifying 1 element in list. , you'd lose benefits of proper data typing. , of proper normalization. , you'd really, annoy whoever has support code in future. particularly when inadvertently stores transaction value of 1,000 rather 1000 in comma-separated string column.

so can, yes. cannot envision situation make sense so.

create table store transactions. create new row every transaction. link each transaction specific person. you'll grateful did.