Q:

more than one value for a column in database

is it possible to store more than one value in database column. if yes which type i should use? and through my java code how can i insert the values.
for example i want to have a column "language" which can store values like java, c++, c# etc. for a single row.
EDIT : i want to have a table called student with all the information about a student with a column to store the names of languages he knows.

A:

You should create a table "language" with all the different languages you want to use, and then use a foreign key to link to this table from a LanguageID column in your other table.
Edit: If you want more than 1 language for a given record then you will need to also create a linking table which links the record to a given LanguageID. Then you can put any number of different languages in for a given record by creating new records in the linking table.

A:

Storing several values in a single column is usually not a good idea, since it violates the principles of database normalization.
From your description it sounds like you have a many-to-many relationship. Implementing it by storing several values in a column would force you to work harder than necessary whenever you want to update the column, or query by a language.
It's technically possible to think of a workaround (as Telcontar suggested, for example), but I would recommend reading a bit about the different normal forms, and reconsidering the database design.

