The table is given:
CREATE TABLE salaries2 (
Employee_mark INT NOT NULL,
an NUMBER (4) NOT NULL,
luna number (2) NOT NULL,
income base NUMBER (16.2),
increase NUMBER (16.2),
tax NUMBER (16.2),
NUMBER retainers (16.2),
CONSTRAINT pk_salaries PRIMARY KEY (employee_brand, year, month),
CONSTRAINT ck_salarii_an CHECK (an between 2001 and 2012),
CONSTRAINT pk_salarii_luna CHECK (luna BETWEEN 1 and 12)
Write a function that determines the net income of the employee with the registration number "employee_mark" (input parameter. Net income = Basic income * (bonuses / 100) - tax - withholdings).
Give an example PL / SQL execution block that defines a cursor that changes the hourly wage by 10 percent more, if it is lower than the value of 24 lei / hour.
4 freelancers estão ofertando em média €20 nesse trabalho
Hello, I can develop the function and the PL/SQL block for you. required. I have more than 12 years of experience in Oracle PL/SQL development. It will be a pleasure to work for you. Kind regards.
Hi Sir, I can do this PL SQL Task in Oracle. I can start now I have seen your job requirements and I am sure that I can do your task efficiently in less timeline as I am an expert Oracle developer Thank, Hasnain