SQL

Oracle

TASK - Create a function that returns the length of a mediatype from the mediatype table.

I am not sure how I am suppose to get the code below to work.

Below is what I currently have:

CREATE OR REPLACE FUNCTION getLength (name Varchar2) RETURN length as Begin Select * INTO Length; return Length; END; / select getLenght(MEDIATYPE.name) from dual;

The error I get is below:

ORA-00904: "GETLENGHT": invalid identifier 00904. 00000 - "%s: invalid identifier" *Cause: *Action: Error at Line: 67 Column: 8

I am still new to SQL so I am not sure how to approach this issue.