Question: Q3. Write a separate script to: Display all the different types of accounts Accept account type and a balance value from the user using accept
Q3. Write a separate script to: Display all the different types of accounts Accept account type and a balance value from the user using accept command and substitution variables Display all customers who has accounts that are similar to the entered account type and its balance is greater than the entered balance value. You have to implement the provided screenshot Hint: search for the SQL*PLUS Accept command which is used to receive input from the user. Below is a sample of the output.

SQL> start C: CPRG250\assignments\assignment1\93.sql ACCOUNT_TYPE 5 rows selected. Please enter account type: 1 Please enter balnce value: 500 bld 4: where account_type = &account_type hew 4: where account_type - 1 old 5: and balance > &balance hew 5: and balance > 500 LAST ACCOUNT_DESCRIPTION BALANCE ------- FIRST ----- John Henri Synge Poincare Chequing Chequing 6433.5 565.23 2 rows selected
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
