Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Joe Celkos Data And Databases Concepts In Practice

Authors: Joe Celko

1st Edition

1558604324, 978-1558604322

Students also viewed these Databases questions

Question

Understand why customers complain.

Answered: 1 week ago