Question: Write a PL/SQL code that accepts the account number from the user and check the users balance. If it is greater than 1000 , only

Write a PL/SQL code that accepts the account number from the user and check the users balance. If it is greater than 1000 , only then deduct Rs. 200/- from the balance . The process is fired on the Accounts table.

Write a PL/SQL code that accepts the account number from the

2. Write a PL/SQL code that accepts the account number from the user and check the users balance. If it is greater than 1000 , only then deduct Rs. 200/ - from the balance. The process is fired on the Accounts table

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!

Q:

Use C++ Please Read Carefully and use file handling and oop concepts and no need to make gui just the code should work Requirements Document: A local bank intends to install new automated teller...

Q:

In Java program, please show the output of this program. A local bank intends to install a new automated teller machine (ATM) to allow users (i.e., bank customers) to perform basic financial...

Q:

LAB2 PART 2 FOR THE DATA TYPYE CLASSES: -Add to the project of part 2, the class Account_yourLastName (from part1) -Add to the project of part 2 two more classes: class CheckingAccount_yourLastName...

Q:

IF YOU DO NOT HAVE THE UML and PSEUDO-CODE, YOU HAVE TO READ THE BELOW REQUIREMENT THEN CREATE UML OF DATA TYPE CLASS AND WRITE THE PSEUDO-CODE BEFORE WRITING THE CODE DATA TYPE CLASS Class...

Q:

Chapter 1 Introduction to Accounting NAME ___________________________________________________ DATE _______________________________ 1. Which of the following events would be recorded as an accounting...

Q:

C++ ' This homework assignment gives you the opportunity to practice nested structures passing a structure by reference and dynamic allocation of an array of structures. There is an extra credit...

Q:

Based on your Lab 10 (BankAccount and SavingsAccount, and exception classes), do the following: Part One: Modify the existing classes If there are any problem and error in your Lab 10, fixed them. In...

Q:

PL/SQL Auction Program 1. Create a user xyz, who is the owner of the auction. Create the schema, and package. 2. Create users x1 and x2 who are the participants in the auction. They will need acces...

Q:

There are two problems due this week (each worth 35 points) as follows. Problem 1.6 (page 20) In comprehensive paragraphs, answerrequirements a to e. You will have 5 paragraphs total of four to five...

Q:

I need help recoding my code. It is in java. For the recoding could you highlight or bold the changes I need to do for my code. Thank you. Here are the problems I am having with my code. 1.You have...

Q:

1. What are the advantages and possible drawbacks to Wilsons title-transfer scheme? 2. Which stakeholders are affected by this approach, either positively or negatively? How great are their...

Q:

If the current liabilities of Bassem's Company for 2019 are $85,000 and for 2020 it is $45,000, current assets for the year 2020 are $90,000 and net cash flow from operating activities for the year...

Q:

An organization has a network with 5 servers running Windows Server and they have decided to purchase Device CALs for all devices. How many of the Windows Servers will the client machines legally be...

Q:

minimum cost by 4 days is

Q:

Do members seem to feel a sense of solidarity with one anotherfor example, by sharing responsibility for both successes and failures?

Q:

Relational Contexts in Organizations

Q:

C Can virtual teams ever build group relationships if they can never communicate in real time?