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.

"Get 15% discount on your first 3 orders with us"
Use the following coupon
"FIRST15"

Order Now