Question: creat function in oracle apex i have a database table here , in the emplyee table i want to creat a function to calclate the

creat function in oracle apex

i have a database table here , in the emplyee table i want to creat a function to calclate the discount that is allowed to give to a customer and we assumed that employee cant give a discount to customer more than he is allowed by shop manager

Ilillinl!l - Assuming the employee cannot give a discount to the customer more than he is allowed by the shop manager

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!

this subject is database management, it's my project please solve this i just need the er diagram and creating tabels please Semester I, 2022-2023 TERM PROJECT - HandoutH2 GENERAL ISSUES Throughout...

i have these tabels in database system , in table employee i have discount_allowed , i want to creat a function to calculate the discount allowed in oracle apex /using pl , sql \begin{tabular}{l}...

Database Administration CHAPTER OBJECTIVES I Understand the need for and importance of database I ttno'illI the meaning of ACID transaction administralin - Learn the tour 1992 ANSI standard isolation...

You have been tasked to develop the architecture for a mine pump control system, designed to monitor and pump flood water out of mine shafts. As underground mining operations take place far below the...

PROJ6000: Principles of Project Management Assessment Assessment 2 - this is actually a case study and its called a Individual Report: PMBoK versus PRINCE2 or Agile in contemporary projects . so one...

this is my assessment which are am going to send you and i need some things about my assessment : Adding some more detail and diving into the case study a bit deeper would really make your points...

1. Read the case study below. This will form the basis for your Project Charter, because you will assume that you are the project manager for this project. 2. After reading the case study, begin to...

1. Read the case study provided below. This will form the basis for your Project Charter, because you will assume that you are the project manager for this project. 2. After reading the case study,...

1. List four inert atoms from the Periodic Table. 2. List four metals from the Periodic Table. 3. Find the mass in kilograms of the 158O atom. Its mass in atomic mass units is 15.003065 u. 4. Find...

1. Create your personal self-concept inventory by addressing the following: What moods or feelings best describe you (c.g. cheerful, happy, sad, grumpy, angry, iritable, depressed, ete.)? Are you...

sample or specimen of adjusted set of financial statements that reflect the company's Net operating assets and its operating income expected to persist into the future, excluding one - time items,...

Scenario You are the financial analyst of an investment company. The managing director of your company is considering to diversify its investment into a healthcare company as the healthcare industry...

Employee ownership plans (employee share options or stock ownership plans) are likely to be more prevalent in countries with low power distance (reflecting an egalitarian attitude towards ownership),...

Power distance: the extent to which reward is based on hierarchical position rather than task performance, and the level of pay differentials between hierarchical levels;

3 How do measures of success of motivational systems vary among different countries cultural contexts?