Oracle 18c

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE my_table (course_id int,col varchar2(200))
INSERT INTO my_table VALUES(1,'Course grade for <font color="#FF0000">Student Name</font>')
1 rows affected

INSERT INTO my_table VALUES(1,'Course grade for <font color="#FF0000">abel </font>')
1 rows affected

SELECT SUBSTR(col, instr(col, '>',1,1)+1, instr(col, '</',1,1) -  instr(col, '>',1,1) - 1) FROM my_table where course_id=1

SUBSTR(COL,INSTR(COL,'>',1,1)+1,INSTR(COL,'</',1,1)-INSTR(COL,'>',1,1)-1)

Student Name

abel