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.

Q3. Write a separate script to: Display all the different types of

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!