Question: Create a PL / SQL function REMOVE _ NN ( NN are your initials ) . The function has two parameters: ( 1 ) string
Create a PLSQL function REMOVENN NN are your initials
The function has two parameters: string of characters possibly including space and 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 REMOVENN Daniella Almonte' 'AEIOUYaeiouy will return the string 'Dnllllmnt'In your answer, please include the SQL create statement and the test results using names FULLNAME of customers from COCUSTOMERS and removing at least characters and space, using one customer name from COCUSTOMERS and removing all characters.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
