Fetching a single or multiple record in a view based on a column value.

Hi,

I have a requirement where I need to fetch single or multiple records based on a particular column value. Let me explain with an example.

I have a custom table student_tbl.

Table has 2 columns - student_name VARCHAR2(60), courses VARCHAR2(1000).

This table stores student name and the courses that he has undertaken.

So if a student has taken only Mathematics, then the table has entry:

student_name - <NAME_OF_STUDENT>

courses - Mathematics

If he has taken 2 courses, then the courses should be stored using a delimiter ","

E.g., the student has taken Mathematics and Physics, then the table has an entry