Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started