You want to count the number of cells in a column that contain text and are longer than 10 characters. Which function would you use?*COUNTLONGCOUNTTEXTLENCOUNTIFS

Create a simple function named characterCount that takes a string and count the characters in the string. The function will return the number of characters in the given string.Use the skeleton file, to develop the function.FUNCTION characterCount(str IN VARCHAR2)   Function name : characterCountparameters  :  str datatype VARCHAR2Function return type : NumberNote:Do not change the function nameDo not change the argument count and orderDo not change the output text.You can query the table records using select statementDelimiter / is mandatory. If delimiter is missed, then while executing nothing will be displayedWhile executing, if you get WARNING: FUNCTION CREATED WITH COMPILATION ERRORS, then use SHOW ERRORS to display the errors in the function.Instructions:1. Create the function successfully2. Once the function is created, check the functionality of the function using appropriate select call3. DO NOT submit the select statement. Submit only the CREATE FUNCTION query.Sample Input and Output:If we execute the function with "HELLO" it should return 5.SubmitPreviously Executed Queries

The function LEN() returns the total number of characters in a string

Question 2A data analyst works with a spreadsheet containing project plan IDs that must be exactly 25 characters long. To ensure accuracy, they use a function to count the number of characters in cell E50. What is the correct syntax of the function?1 point=LEN(25, E50)=LEN(E50)=LEN(25)=LEN(E50, 25)

To find the number of alphabets in a sentence written in cell A1, which out of the following options is precise? Ops: A. LEN(A1) B. LEN(TRIM(A1)) C. TRIM(LEN(A1)) D. LEN(A1)(TRIM(A1)

1 MARKRevisit Fixing the length of a text string in a cell is done by