Question: Create a PL / SQL function REMOVE _ NN ( NN are your initials ) . The function has two parameters: ( 1 ) string

Create a PL/SQL function REMOVE_NN (NN are your initials).
The function has two parameters: (1) string of characters (possibly including space), and (2) string of characters to be removed.
The function returns a string without the removed characters.
The input strings will be not NULL and not empty. However, the output could be a string with all characters removed.
Example:
The function REMOVE_NN ('Daniella Almonte' , 'AEIOUYaeiouy ') will return the string 'Dnllllmnt'In your answer, please include the SQL create statement and the test results (1) using 10 names (FULL_NAME) of customers from CO.CUSTOMERS and removing at least 3 characters and space, (2) using one customer name from CO.CUSTOMERS and removing all characters.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!