Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started