Answered step by step
Verified Expert Solution
Link Copied!

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.

image text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Hands On Database

Authors: Steve Conger

1st Edition

013610827X, 978-0136108276

More Books

Students also viewed these Databases questions

Question

How have local credit unions performed over the last 20 years?

Answered: 1 week ago