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