CREATE TABLE  tbl_Students (
    Studentid number NOT NULL,
    Firstname varchar2(200) ,
    Lastname varchar2(200) ,
    description varchar2(400),
    course varchar2(200),
    title varchar2(200),
    course_id numeric
--    constraint course check(course is JSON)
);

Insert into tbl_Students (Studentid,Firstname, lastname, description)
 Values(1111,'Vivek', 'Johari', 'course=SEA14 - 1730 Min,title=9352818303,course_id=1212');

Insert into tbl_Students (Studentid,Firstname, lastname, description)
 Values(1112,'Pankaj', 'Kumar', 'course=SEA15 - 1731 Min,title=6552818303,course_id=1213');

Insert into tbl_Students (Studentid,Firstname, lastname, description)
 Values(1113,'Amit', 'Singh', 'course=SEA14 - 1732 Min,title=4352818303,course_id=1214');
 
commit;

WITH 
JSon_Students AS ( 
  select Studentid, TREAT('{' || REPLACE(REPLACE(description, '=', ':"'), ',', '",') || '"}' AS JSON) json_desc from tbl_Students) 
select js.Studentid, js.json_desc.course, js.json_desc.title, js.json_desc.course_id 
from   JSon_Students js