Subject Computer Science Database Development

Question

Write an anonymous PL/SQL block that accepts a string as input and removes all of the vowels (a.e.i.o.u) from the string, then outputs the results.
The output should look like this:
Run the Program
SQL>@rm_vowels
Enter the String: A penny for your thoughts
SQL>****************************
SQL>The new string is: pnny fr yr thghts

Solution Preview

This material may consist of step-by-step explanations on how to solve a problem or examples of proper writing, including the use of citations, references, bibliographies, and formatting. This material is made available for the sole purpose of studying and learning - misuse is strictly forbidden.

Solution I (PL/SQL block):

set serveroutput on
set verify off

accept vstring prompt "Enter the String: ";
declare...

This is only a preview of the solution. Please use the purchase button to see the entire solution

$5.00

or free if you
register a new account!

Assisting Tutor

Related Homework Solutions

Creating Databases Using MS Access
Homework Solution
$20.00
Databases
MS Access
Business
Management
Employees
Department
Relationships
Primary Key
Foreign Key
Tables
UML Class Diagram
Get help from a qualified tutor
Live Chats