I need a separate script to: display all the different types of accounts accept an account type from the user using substitution variables display...

I need a separate script to:

 display all the different types of accounts

 accept an account type from the user using substitution variables

 display all the transactions for the input account type.

Notice that the script is case insensitive and works for partial matches of the account type.

Solve using Traditional Join. Research how to use the SQL*PLUS Accept command.